importing foreign characters into Access

[Kathy MacAthur]

Hi - hope you can help with this.

I am importing a text file that includes accented characters within names
and streets, into an MS Access table. I've used this import procedure for
many years but occasionally have the problem where accented and foreign
characters are not imported improperly and come out looking funky (not how
it was intended). Then when we do a mailing the "funky" character appears.
I am stuck with this text file import procedure.

Is there a mod to the import function that will allow for the proper input
of foreign character sets?

Thanks in advance,

Kathy

 

[John Nurick]

Hi Kathy,

If you're importing via the Text Import Wizard, click the Advanced
button and select a code page. The first one to try is probably
OEM(DOS).

If using TransferText, use the Text Import Wizard to set up an import
specification that includes the code page you established above.