Any way to convert database from MS Excel to MySQL

suneeya's Avatar, Join Date: Sep 2013
Newbie Member
I am looking for solution to convert my MS Excel database record into MySQL database.
Is there any suggestion for database conversion?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Just save the the xls file as CSV and then import the data from the CSV file into a MySQL table.
0
suneeya's Avatar, Join Date: Sep 2013
Newbie Member
Hello Mr. shabbir
I need your help. I am on wrong forum. Can you tell how i can delete my thread from here?
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
What do you mean by wrong forum and which thread you want to delete and I will do that for you.
0
alia123's Avatar, Join Date: Jan 2016
Contributor
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....