Ahmed Merghani
asked on
Importing data to mysql from excel file
Hi,
I have an excel file contains data. I want to import this data in Mysql database. Is there any tool or script can be used to do such thing? Put in mind the file contains utf8 data.
Thanks in advance
I have an excel file contains data. I want to import this data in Mysql database. Is there any tool or script can be used to do such thing? Put in mind the file contains utf8 data.
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your response.
It gives me this error:
It gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`' at line 1
Did you select CSV as the format on import? That looks like the kind of error you would get when importing an SQL file.
ASKER
Yes I did. Attached part of the CSV file
123.csv
123.csv
ASKER
Ok that was the problem and now it works. I did not realize that encoding is not utf8!! I changed the encoding to utf8 and then I import the file without creating the table and it works.
ASKER