Q
Problem solve Get help with specific problems with your technologies, process and projects.

Converting an Excel file to MySQL

I have this query where I have to convert Excel files to MySQL databse files, and I have to write a script. Please help.

The easiest way to convert an Excel table to MySQL is to dump the table to CSV format, then use LOAD DATA INFILE to load it into a MySQL table. The syntax for loading a CSV file is as follows:

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
          FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
          LINES TERMINATED BY '\n';
Full information on LOAD DATA INFILE can be found at http://dev.mysql.com/doc/mysql/en/load-data.html.

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close