how to import from MS excel into MYSQL DB [duplicate]

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

arober11
– arober11

2012-12-02 23:08:28 +00:00
Commented Dec 2, 2012 at 23:08 — arober11
– arober11, Commented Dec 2, 2012 at 23:08

joeslice · Accepted Answer · 2009-09-16 11:20:28Z

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, 2009 at 11:20

joeslice

3,4741 gold badge21 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeff Fritz · Accepted Answer · 2009-09-16 11:21:33Z

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, 2009 at 11:21

Jeff Fritz

9,8817 gold badges45 silver badges52 bronze badges

Comments

mkolodziejski · Accepted Answer · 2009-09-16 11:21:11Z

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, 2009 at 11:21

mkolodziejski

743 bronze badges

Comments

Andrew Kozak · Accepted Answer · 2012-04-02 14:51:46Z

1

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

edited Apr 2, 2012 at 14:51

Andrew Kozak

1,6602 gold badges22 silver badges35 bronze badges

answered Apr 2, 2012 at 13:12

a82r

111 bronze badge

Collectives™ on Stack Overflow

how to import from MS excel into MYSQL DB [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related