Imported Text Strings changing!

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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).
 
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?
 
Back
Top