Importing text files with accents into Access

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

Guest

I have a txt file containing names and address, some of which have accents.
I'm able to import everything into Access but any letters containing accents
come out as giberish. I've got my language bar set to United States -
International and I'm got the "Import Specification" language set to "ALL"
and the Code Page set to "OEM United States". Any ideas what may be causing
the problem?
 
Try using a different code page. Probably you need Western Europe
(Windows).

On Thu, 2 Dec 2004 13:45:11 -0800, "Sergio Asensio" <Sergio
 
John,

You got me on the right track. The problem was with the Code Page as you
indicated. When I selected "auto-select" instead of "OEM United States" the
import worked perfectly and I got all the accents.

Thanks!!!
 
Sergio's solution does not solve the same problem for me. I am importing a
tab delimited text file into Access 2003, with Import Specification of "All"
and Code Page of "Auto-select" ( though I have tried Western Europe Windows
and several others) to no avail. The text value 'Sören' appears in Access as
'Sören'.

Please help!
Thanks,
Elaine
 
Back
Top