export data with french characters from MS ACCESS to .txt

R

RayB

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TXT Files with French accented characters 2
EXPORT QUery with memo field to excel, truncated data 2
Formatting in export to ms excel 2
Export Access with Chinese Characters to Hong Kong MYOB 1
Export Access Table with Memo Field to Excel 2
Export to Ms Project or Ms Access 0
Automated Export From Access To TXT 1
Export Access Data to Excel/Reimport modified data into Access 5

Top