Need xsl to MySQL unicode import advice

Asked By 80 points N/A Posted on -
qa-featured

Hello! Can you advice xsl to MySQL unicode importing method? I have tried to export it to CSV but original excel file contains unicode giving wrong format to original after this modification. Do I need to create form or there is other way?

Thank you for your help.

SHARE
Answered By 0 points N/A #149663

Need xsl to MySQL unicode import advice

qa-featured

Hi,

Follow these steps to import data from xsl to MySQL:

1. Open the excel file and save the excel data file as CSV data file.
2. Using notepad as a text editor check the used file.
3. Begin the MySQL Command Prompt.
4. Put this command: LOAD DATA LOCAL INFILE ‘C:\temp\filename.csv’ INTO TABLE database. table FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘rn’ (field1, field2);
5. At this time the data file is imported.

Best regards,

Heather marie

Login/Register to Answer

Related Questions