Imported Text Strings changing!

[Guest]

Hi, I am trying to import text strings into an access table. Some of the text
contains characters (eg the German ö, letter o with diaeresis), when I
inspect the loaded string in Access has converted it to the division
character double bar with dot above and below like ÷.

Why is this?

Is there a system switch or other change I need to make to allow many
different character sets to read without this parsing of text strings?

Many thanks

 

[Guest]

Hi Nigel,

You don't say how you're importing the strings. If you're using the text
import wizard (File|Get External Data), click the Advanced button and adjust
the code page/character set. If you're using DoCmd.TransferText or the
TransferText macro action, use the wizard to create and save a text import
specification including the code page setting (or you can use schema.ini if
you prefer).

 

[Guest]

John,

I will be doing both, so thanks for the tips either way. It worked!

Cheers
Nigel

 

[Guest]

That's strange since the two characters have different ascii reference
numbers. Can you post up your code so I can take a look at it?