Import Error

Import Error

am 03.11.2007 02:18:26 von mohanng

Hi When i Import .txt file in to Access Data Base a special Characters
like "âˆ=A9" and "╗┐" is getting added to the Access ta=
bles. can any one
suggest me how to take out this Special characters.

I checked the .txt flies but there is no such special characters in it

Re: Import Error

am 03.11.2007 05:44:29 von Tom van Stiphout

On Fri, 02 Nov 2007 18:18:26 -0700, mohanng@gmail.com wrote:

How did you check the txt files? With a Hex editor? That's the only
reliable way. Notepad and other editors will try to be helpful,
messing up your interpretation.
My guess is that your file is a UNICODE file.

-Tom.


>Hi When i Import .txt file in to Access Data Base a special Characters
>like "?" and "??" is getting added to the Access tables. can any one
>suggest me how to take out this Special characters.
>
>I checked the .txt flies but there is no such special characters in it