SoonerInKCMO
3/26/2008, 05:01 PM
:mad: :mad:
So, I have to create some .csv files with data about our Chinese employees to send to some payroll vendors. In order to get the Chinese characters (names and addresses) to show up correctly, I've had to use UTF-16 encoding for the file (maybe some other encoding will work too... but I haven't found it). The characters show up fine but Excel doesn't recognize the .csv as... well, a .csv - opening up the file, I get all of the fields in a row in the first column. The commas are displayed just fine - they're just not making Excel put the data into separate columns.
Anyone have any ideas about how to fix this??
So, I have to create some .csv files with data about our Chinese employees to send to some payroll vendors. In order to get the Chinese characters (names and addresses) to show up correctly, I've had to use UTF-16 encoding for the file (maybe some other encoding will work too... but I haven't found it). The characters show up fine but Excel doesn't recognize the .csv as... well, a .csv - opening up the file, I get all of the fields in a row in the first column. The commas are displayed just fine - they're just not making Excel put the data into separate columns.
Anyone have any ideas about how to fix this??