If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accent marks Access 2003
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Accent marks Access 2003
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. -- Ken Snell MS ACCESS MVP "Ian Bayly" wrote in message ... 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 |
#5
|
|||
|
|||
Accent marks Access 2003
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)" wrote in message ... 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. -- Ken Snell MS ACCESS MVP "Ian Bayly" wrote in message ... 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 |
#6
|
|||
|
|||
Accent marks Access 2003
Interesting that it isn't working though....
-- Ken Snell MS ACCESS MVP "Ian Bayly" wrote in message ... 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)" wrote in message ... 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. -- Ken Snell MS ACCESS MVP "Ian Bayly" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|