importing accented DOS chars

  • Thread starter Thread starter Jon Weston
  • Start date Start date
J

Jon Weston

Hi there. I'm trying to import DOS characters with foreign accents (grave,
acute, circumflex, etc) into Text fields in a table in Access97 but Access
seems to be converting them along the way. eg. an E with an accent acute
somehow gets imported as a comma. How can I get Access to leave the chars
alone?

Thanks,
Jon
 
Hi Jon,

The problem is that Access *is* leaving them alone, but the encoding has
changed between DOS and Windows. Assuming you're importing from a text
file, click the Advanced button in the Text Import Wizard and select the
appropriate code page (may be called encoding or character set; I don't
have Access 97 at hand).
 
John Nurick said:
Hi Jon,

The problem is that Access *is* leaving them alone, but the encoding has
changed between DOS and Windows. Assuming you're importing from a text
file, click the Advanced button in the Text Import Wizard and select the
appropriate code page (may be called encoding or character set; I don't
have Access 97 at hand).
Click to expand...

You're a bloody genius! You can select either "Windows(ANSI)" or "DOS or
OS/2" and, of course, mine was left on Windows. Once switched it worked
wonderfully. Thanks.
 
Back
Top