Search results

First I apologize for what must be a fundamental question that has been answered many a time. I have read over a dozen posts in this forum about this and am using the suggested methods. Dim strSQL As String strSQL = "SELECT tblPOS_Import_Prelim.* From tblPOS_Import_Prelim ORDER BY...

Awesome! I'll take a look. It's so odd that importing data into a table preserves the characters, even the Unicode-only, and you can program based on the codes, but displays outside of the imported data (e.g., code/immediate window) will not display the characters. I know it's about language...

Ah, got it! Totally misunderstood what that was. The L with a line through it (a "strike" as it's apparently called) is one of several Polish characters I have to deal with which cause headaches as they do not have ASCII codes, as you are aware. I am intrigued by your note of looping a language...

Excellent - I thought my start at a reference table with Latin equivalents was going to be my key but I like this method much better. Q1 - when I copy the "UPDATE" code into my module, I'm getting an "expected: end of statement" error at the end of the first line (where the comma is located)...

Here's an Excel dump of the customer info. Once I get past an update of the customer name, updating the other fields as necessary should be simple...right??

Having to step back into VBA programming on a couple database after several years away. Rusty!!! Dataset: data files from global business partners, some of whom send data using foreign characters. Situation: I've done my research and programming and have built a procedure to scan the necessary...