View Single Post
  #3  
Old May 17th, 2007, 10:05 PM posted to microsoft.public.access.tablesdbdesign
Ian Bayly
external usenet poster
 
Posts: 6
Default Accent marks Access 2003

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)" wrote in message
...
Set the Unicode Compression property for the text-data-type fields to No.
ACCESS should handle such characters without difficulty.

--

Ken Snell
MS ACCESS MVP



"Ian Bayly" wrote in message
...
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