By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,654 Members | 1,422 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,654 IT Pros & Developers. It's quick & easy.

How to make access import special chars correctly?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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********@hotmail.com> wrote in message
news:sC*********************@news4.srv.hcvlny.cv.n et...
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

Nov 13 '05 #2

P: n/a
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********@hotmail.com> wrote in message
news:sC*********************@news4.srv.hcvlny.cv.n et...
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


Nov 13 '05 #3

P: n/a
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********@hotmail.com> wrote in message
news:R7*********************@news4.srv.hcvlny.cv.n et... It is a tab delimited text file

I am using windows 2002.

Thanks

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.