Accent marks Access 2003

[Ian Bayly]

I am importing to a table a large text file containing names. This table is
then amended and the names exported to another text file
Many of the names are of European origin and have accent marks. as examples
(if they view correctly) á, ð, é, í
While these show properly in the incoming text file (viewing via notepad)
they will not import correctly into my table.
I have tried most likely code pages in the "Advanced options" section of
importing, with no luck.

Am I missing a basic Access option?

TIA

Ian B

 

[Ken Snell \(MVP\)]

Set the Unicode Compression property for the text-data-type fields to No.
ACCESS should handle such characters without difficulty.

 

[Ian Bayly]

Thanks for the advice Ken.
The imported table defaults to this setting = No so it does not affect the
result.

Any other ideas.?

Ian B

 

[Ken Snell \(MVP\)]

What is the Language setting that you're using in the Advanced window of the
import wizard box? Change it to All if it's on English.

 

[Ian Bayly]

Thanks again Ken.
It was set to ALL.

Expediency forced me to convert the text file to an Excel sheet and then
link that as an Access table.
This brings all the diacritics in just fine.

Cheers

Ian B

 

[Ken Snell \(MVP\)]

Interesting that it isn't working though....