How can I import data from excel to MYSQL?

Question

I tried to import the data from excel to MYSQL by using the following command:

  load data local infile "filepath" into table mytab;

But this command is work for import the data from text file not for csv file or xlsx. I want to import the data directly from excel to MYSQL.

dev2d · Accepted Answer · 2013-06-18 12:26:29Z

1

check following, see the seperator in your csv file and make sure you provide the correct one in command. Referance Link

answered Jun 18, 2013 at 12:17

dev2d

4,2823 gold badges33 silver badges56 bronze badges

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

Comments

Burhan Khalid · Accepted Answer · 2013-06-18 12:17:41Z

0

You need to convert your Excel sheet into a CSV file, or use MySQL for Excel to help with the process.

answered Jun 18, 2013 at 12:17

Burhan Khalid

175k20 gold badges255 silver badges292 bronze badges

Triclops200 · Accepted Answer · 2013-06-18 12:18:25Z

0

load data local infile "filepath" into table mytab fields terminated by ';' enclosed by '"' lines terminated by '\r\n';

Should be the command you need, but you should export to csv first.

answered Jun 18, 2013 at 12:12

Triclops200

8335 silver badges22 bronze badges