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

  • Thread starter Thread starter JE
  • Start date Start date
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.
 
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.
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 <--
 
Back
Top