How to make access import special chars correctly?

[Danny]

Hello
How can I make access import a tab delimited text file that contains a
special char u (but with the dots over it like a german spelling). The u
shows with the two dots in the text file but when it comes into access, it
looks like something else!!.

How can I make access import these special chars correctly?

Thanks

[Michael \(michka\) Kaplan [MS]]

What is the format of the file?

What is the version of Access?

Its hard to advise here without knowing what you are working with....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Danny" <da********@hot mail.com> wrote in message
news:sC******** *************@n ews4.srv.hcvlny .cv.net...

Hello
How can I make access import a tab delimited text file that contains a
special char u (but with the dots over it like a german spelling). The u
shows with the two dots in the text file but when it comes into access, it
looks like something else!!.

How can I make access import these special chars correctly?

Thanks

[Danny]

It is a tab delimited text file

I am using windows 2002.

Thanks

"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******** @news.microsoft .com...

What is the format of the file?

What is the version of Access?

Its hard to advise here without knowing what you are working with....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Danny" <da********@hot mail.com> wrote in message
news:sC******** *************@n ews4.srv.hcvlny .cv.net...

Hello
How can I make access import a tab delimited text file that contains a
special char u (but with the dots over it like a german spelling). The u shows with the two dots in the text file but when it comes into access, it looks like something else!!.

How can I make access import these special chars correctly?

Thanks

[Michael \(michka\) Kaplan [MS]]

I assume you meant Access 2000? Since the question was about version of
Access.

If you hit the Advanced button on the Import Text wiz, you can pick the
encoding of the file, and if you choose correctly then it will properly
import any character in Unicode (which includes the umalut/diaresis, a char
which is nothing special when stacked up against everything in Unicode!).

If you have trouble, then more information -- you mentioned in your first
message that:

>>The u shows with the two dots in the text file but when it
>>comes into access, it looks like something else!!.

What does it look like, precisely?

--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Danny" <da********@hot mail.com> wrote in message
news:R7******** *************@n ews4.srv.hcvlny .cv.net... It is a tab delimited text file

I am using windows 2002.

Thanks