1

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

Community
  • 1
  • 1
gaurav soni
  • 11
  • 1
  • 2
  • It's been asked many times on SO. There's one solution by exporting to CSV and using the SQL command [LOAD DATA INFILE](http://dev.mysql.com/doc/refman/5.1/en/load-data.html). You could also open the table in PHPMyAdmin and import the Excel file. Just search a bit. –  Sep 16 '11 at 09:52
  • I posted a good list of options to accomplish this here http://stackoverflow.com/questions/1310166/how-to-import-an-excel-file-in-to-a-mysql-database/25578291#25578291 – panofish Sep 19 '14 at 19:25

2 Answers2

1

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

Jan S
  • 1,831
  • 15
  • 21
0

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

Devart
  • 119,203
  • 23
  • 166
  • 186