Step By Step procedure to migrate data from Excel to MySql database table [duplicate]

This question already has answe开发者_开发技巧rs here: Closed 11 years ago.

Possible Duplicate:

how to import from MS excel into MYSQL DB

I want the procedure to migrate the excel data into mysql database. Supppose i have excel abc.xls and table in MySql is abc Now what will be step by step procedure . I am using MYSQL.

Please help

---

The easy way would be to use a MySQL client like SQLyog. It has a wizard which allows for easy migration from excel to MySQL.

You can also use the LOAD DATA LOCAL INFILE command to import it directly. Take a look at this for the detailed steps

---

Try Data Import tool (Excel format) in dbForge Studio for MySQL. Command line is supported.