International characters not displaying properly on import

G

Guest

When importing a text file or an excel file that has international characters
such as é, the characters are displayed as gobbly-gook. If I export, I see
that Access has permanently changed them to gobbly-gook. I know there's a way
to fix this, I just don't know what it is. I'm on XP and Office 2003, SP2.
 
J

John Nurick

Hi Rachel,

If it's a text file (including CSV files, which may show up in Windows
as Excel files), click the Advanced button while you're importing it and
select the appropriate code page (character set). It may take trial and
error to find the right one. (If you have to export the data back to the
original source, you may need to set the code page when exporting too.)
 

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

downloaded onlinen db language characters change on import to acce 1
Importing International Phone numbers from text file 1
Foreign character problem in Access Import 4
International characters 1
Export Access with Chinese Characters to Hong Kong MYOB 1
export data with french characters from MS ACCESS to .txt 1
Characters not displaying in Reports 3
How to type accented characters in Outlook 2003? 5

Top