Exporting to CSV file with Chinese Characters in Spreadsheet

G

Guest

I received a file from one of our subsidiaries in Honk Kong. The spreadsheet
has Chinese characters in the spreadsheet that appear and print out just fine
as Chinese characters. But when I export the data to a Comma Separated Value
file, the Chinese characters all appear as question marks. I tried adding the
Chinese language with the Windows XP SP2 CD but it did not make any
difference.

Any thoughts would be welcome. Thanks!

Ron
 
G

Guest

Hi Ron,

I have a feeling that CSV files are always encoded as 8-bit and can't handle
unicode text such as the Chinese alphabet. Can you export the data as HTML
or XML for the purpose in question?

Just a thought,

Mark
 

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

How do I block Chinese characters in email subjects? 2
chinese (UFT-8) in csv files created by a server 1
Problem in reading .csv file with unicode characters 1
Vista english version : handling chinese characters? 6
Export Access with Chinese Characters to Hong Kong MYOB 1
Opening files with Chinese characters in file name 1
Not able to enter Chinese 4 byte characters(GB18030)in MSAccess 20 0
Saving double-byte characters as unicode text in a CSV file 4

Top