Importing text files with accents into Access

S

Sergio Asensio

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?
 
J

John Nurick

Try using a different code page. Probably you need Western Europe
(Windows).

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

Serge Asensio

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!!!
 
E

efortin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Foreign character problem in Access Import 3
Importing text files with French characters in Access 2003 1
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Importing Text in a .csv file 3
Trouble importing foreign language accents into Access 2003 11
importing foreign characters into Access 1
killing accents sos 2
Word 2003 & Greek characters with accents 0

Top