MS Access Database - Chinese Characters

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.

--

Ken Snell
MS ACCESS MVP

"Jose" wrote in message
news
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?

I checked the Unicode and it was set to NO. I added the function First to
the memo field in my select statement and it work. I appreciate your
response to this issue. Thanks a lot!

"Ken Snell [MVP]" wrote:

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.

--

Ken Snell
MS ACCESS MVP

"Jose" wrote in message
news
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?