A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Accent marks Access 2003



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2007, 01:55 AM posted to microsoft.public.access.tablesdbdesign
Ian Bayly
external usenet poster
 
Posts: 6
Default 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  
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



  #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





  #4  
Old May 17th, 2007, 10:44 PM posted to microsoft.public.access.tablesdbdesign
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default 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  
Old May 22nd, 2007, 03:36 AM posted to microsoft.public.access.tablesdbdesign
Ian Bayly
external usenet poster
 
Posts: 6
Default 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  
Old May 22nd, 2007, 04:57 AM posted to microsoft.public.access.tablesdbdesign
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.