ODBC MS Query - chinese character issue

M

Mentos

hi, we have english version of ms excel, query 2003 and windows xp. with
MYOB, some data values are stored in both chinese (traditional) and english.
When i view the data with MS Query, it is fine - i.e. both chinese and
english is displayed as expected. however, when i return the data to excel,
the values that have chinese are corrupt. for each field, the correct chinese
characters are returned, but in ADDITION, some extra characters are
automatically appended.

has anyone experienced this before?
 

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

chinese (UFT-8) in csv files created by a server 1
Acrobat Forms, xml files, Excel csv and the Chinese Language 0
Problem displaying Chinese characters 6
Mail merge with chinese character field 1
Not able to enter Chinese 4 byte characters (GB18030)in MS Access 0
Not able to enter Chinese 4 byte characters(GB18030)in MSAccess 20 0
When is "?" really a "?" (.SaveAs with Chinese chars) 0
Stripping Out Foreign (Chinese) Characters 0

Top