How to import large Excel file table to MySQL database table

Question

I am trying to move my MS Access databases into a single database of MySQL. Each table has at least 50,000 rows and 70 columns. What is the best way to import the data to MySQL tables?

I tried exporting it first to Excel and using the 'MySQL for Excel' add-on but the data seems to large for it to handle efficiently. If there are better ways to do it, please let me know.

waka · Accepted Answer · 2014-10-23 05:51:33Z

2

Export your file to a TXT or CSV and then use this MySQL Command:

LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;

answered Oct 23, 2014 at 5:51

waka

3,4459 gold badges38 silver badges54 bronze badges

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

1 Comment

mfrancisp Over a year ago

I added a few more things in the command but this idea worked. Thanks!

Collectives™ on Stack Overflow

How to import large Excel file table to MySQL database table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related