View Single Post
  #2  
Old May 17th, 2007, 03:57 AM posted to microsoft.public.access.tablesdbdesign
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default Accent marks Access 2003

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