$6.12

How to import an excel file in to a MySQL database??

Ask a question+
0

Can anyone explain how to import a Microsoft Excel file into a MySQL database?

For example, my Excel table looks like this:

Country   |   Amount   |   Qty
------------------------------------------
America   |   93       |   0.60

Greece    |   9377     |   0.80

Australia |   9375     |   0.80
add comment

1 Answer

0

Export it into some text format. The easiest will probably be a tab-delimited version, but CSV can work as well.

Use the load data capability. See http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Look half way down the page, as it will gives a good example for tab separated data:

FIELDS TERMINATED BY ‘\t’ ENCLOSED BY ‘’ ESCAPED BY ‘\’

Check your data. Sometimes quoting or escaping has problems, and you need to adjust your source, import command— or it may just be easier to post-process via SQL.

Azniv Saroyan 150
add comment

Your Answer