|
Home > Archive > MS Access Database with External Data > April 2006 > International characters not displaying properly on import
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
International characters not displaying properly on import
|
|
| Rachel 2006-04-05, 11:37 am |
| 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.
| |
| John Nurick 2006-04-05, 8:28 pm |
| 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.)
On Wed, 5 Apr 2006 09:24:02 -0700, Rachel
<Rachel@discussions.microsoft.com> wrote:
>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.
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|
|
|
|
|