Data files from EXCEL for MySQL

Question

I was trying to output Excel's data to a text file to use them in MySQL, nevertheless i was not able to find an easy solutio because at the end of each row I have to add manually a "TAB" ! Otherwise there are always errors in the MySQL table, is there any special data format to export these data from Excel 2003 ?

Thanx for your help

Alex

This appears to be very similiar to [8031193](http://stackoverflow.com/questions/8031193) — arober11, Dec 02 '12 at 23:05

Eric J. · Accepted Answer · 2010-05-15T18:42:28.040

1

You can load from CSV (comma separated value) format. See here. Are you saving your Excel data as tab separated? If so, save as comma separated and follow instructions in the link.

EDIT:

You probably need to include the

LINES TERMINATED BY '\r\n'

statement. See this blog.

edited May 15 '10 at 18:42

answered May 15 '10 at 18:35

Eric J.

147,927
63
340
553

I tried also with commas but I need to add a comma at the end of the row. Manually and that's the same issue as with TABs – Alex May 15 '10 at 18:37
What version of MySQL are you using? The MySQL documentation examples do not show a comma at the end. – Eric J. May 15 '10 at 18:39

Data files from EXCEL for MySQL

1 Answers1