importing accented DOS chars

[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

 

[John Nurick]

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).

 

[Jon Weston]

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).

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.