export data with french characters from MS ACCESS to .txt

[Guest]

Hello all,

Using MS office 2003 SP@ under Windows XP SP2.

When looking at data in MS aAccess tables, I can see french text with the
proper accented characters.
When I export the data to a .txt file however (to produce a difference
report) all the french accented characters are replaced by a "?".

This has happened since we changed computers for everyone so I suspect we
are missing a setting or an environment variable that we forgot to carry over.
I have been searching all afternoon and this is starting to "Peeve" me as in
Potter lore...

Thanks for the help

RayB

 

[John Nurick]

Hi Ray,

The first thing I'd do is experiment with the code page/character set
setting in the Advanced dialog in the Text Import Export wizard.