Have Geek Brain

Data files from EXCEL for MySQL

I tried to output the Excel data to a text file to use in MySQL, however I could not find a simple solutio because I have to manually add "TAB" at the end of each line! Otherwise there are always errors in MySQL table, is there any special data format for exporting this data from Excel 2003?

Thanx for your help

Alex

+2


a source to share


1 answer


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

EDIT:

You probably need to include



LINES TERMINATED BY '\r\n'

statement. See this blog .

+1


a source






More articles:


All Articles