how to import from MS excel into MYSQL DB

Question

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

This appears to be very similiar to [8031193](http://stackoverflow.com/questions/8031193) — arober11, Dec 02 '12 at 23:08

score 6 · Answer 1 · answered Sep 16 '09 at 11:20

6

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;

answered Sep 16 '09 at 11:20

joeslice

3,454
1
19
24

score 3 · Answer 2 · answered Sep 16 '09 at 11:21

3

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

answered Sep 16 '09 at 11:21

Jeff Fritz

9,821
7
42
52

score 2 · Answer 3 · answered Sep 16 '09 at 11:21

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

answered Sep 16 '09 at 11:21

mkolodziejski

74
3

score 1 · Answer 4 · edited Apr 02 '12 at 14:51

1

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

edited Apr 02 '12 at 14:51

Andrew Kozak

1,631
2
22
35

answered Apr 02 '12 at 13:12

a82r

11
1

how to import from MS excel into MYSQL DB

4 Answers4

Linked

Related