Characters not recognized by Access in source data (e.g., apostrop

J

JE

I created an Access table by accessing external tables (using ODBC). The
problem is that the source data contains characters that Access does not
recognize such as apostrophe, quotes and bullets. The resulting table
displays these as a diamond with a question mark. Is there a workaround for
this such that the character is displayed? Many thanks.
 
S

Stefan Hoffmann

hi,
I created an Access table by accessing external tables (using ODBC). The
problem is that the source data contains characters that Access does not
recognize such as apostrophe, quotes and bullets. The resulting table
displays these as a diamond with a question mark. Is there a workaround for
this such that the character is displayed? Many thanks.
Click to expand...
This is normally charset problem. Access doesn't know how to display it.
Take a look at th ODBC driver, maybe you can tweak it there.


mfG
--> stefan <--
 
Top