how to import from MS excel into MYSQL DB [duplica

Question

This question already has answers here:

How to import an excel file in to a MySQL database (11 answers)

Closed 6 years ago.

How do I import data from MS excel and insert in to MYSQL database ? Which language is easiest and fastest to do this task ?

Answer 1

If you can safely represent everything in a CSV format (just export from Excel) then you need only one command:

LOAD DATA INFILE '/tmp/coolfile.txt' INTO TABLE coolTable; 

Answer 2

Not really a programming question, the fastest method I would suggest is export data from Excel to CSV-file, and then import it into MySQL using LOAD DATA INFILE command.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Answer 3

In Windows, you can use phpMyAdmin's import feature. It has many options including import from Microsoft Excel!

Answer 4

I would use the swiss army knife of data manipulation in the windows world:

MS Access

Import the Excel sheet into an Access table, and export the table over ODBC to MySQL