Any way to convert database from MS Excel to MySQL

suneeya · Sep 21, 2013

I am looking for solution to convert my MS Excel database record into MySQL database.
Is there any suggestion for database conversion?

shabbir · Sep 21, 2013

Just save the the xls file as CSV and then import the data from the CSV file into a MySQL table.

suneeya · Oct 9, 2013

Hello Mr. shabbir
I need your help. I am on wrong forum. Can you tell how i can delete my thread from here?

shabbir · Oct 10, 2013

What do you mean by wrong forum and which thread you want to delete and I will do that for you.

alia123 · Feb 10, 2016

Hey,check this link " http://dev.mysql.com/doc/refman/5.1/en/load-data.html ".
You will get the exact data you need.

Good Luck....