Q

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.

This was first published in March 2005

Dig deeper on Open source databases

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close