International characters not displaying properly on import

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.)
 
Back
Top