MS Access Database - Chinese Characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When we load data from Excel using a MS Access 2000 database and it is open
with MS Access 2000, we get chinese characters in one column after running an
append query against the data. The datatype for the column is memo. The
queries were created in the same database using MS Access 2003. When I load
the data from Excel and run the append query in MS Access 2003, everything
seems to work fine. This was also tested in MS Access 2002 and it works fine
too. No Chinese characters. Has anyone seen this type of problem in the
past? Is there a fix to this problem?
 
Could result from one or both of these situations:

(1) Your memo field has Unicode Compression set to Yes. Try changing it to
No.

(2) Your query is using the memo field in a GROUP BY clause. Change the memo
field to use First instead of Group By in the query.
 
Back
Top