Error: importing a UTF-8 CSV file

E

EXCEL2000HMC

I have an error when opening a CSV file when encoded as UTF-8 in Excel, it takes the text literaly without transforming some double byte characters. From what I understand UTF-8 is a mixed byte format. Can anyone help me

I only know of a work-around to open the CSV file in Notepad.EXE and save the file as a two byte (unicode) setting. Then open the within Exce

Is there a better way
 

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

open UTF8 CSV 0
How to create a csv file with UTF-8 encoding 0
Error when opening a CSV file when encoded as UTF-8 0
how to configure Access to Link to a UTF-8 database? 2
UTF-8 File Opened in Excel from Firefox Browser 1
Convert UTF-16 Unicode to UTF-8 Unicode? 1
Convert UTF-16 Excel file to UTF-8 and back 1
Open a CSV how God meant it 1

Top