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.
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 <--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Help! Character Encoding Problem when exporting from Access to XML 3
Getting 'Smart Quotes' out of Access 7
How do I match first 16 characters? 6
special characters in text strings 3
Manage ODBC 2
Data Access Pages Data Source 2
Strange Asian looking characters in output 3

Back
Top