Page 1 of 1

migrating data from excel

Posted: Mon Oct 27, 2003 4:51 am
by yaron
How can migrate data form excel sheet to mysql database?
I've heard that to import *.csv file might be helpful but I don't really know what is *.csv and how can i use it.
andy ideas?

Posted: Mon Oct 27, 2003 5:06 am
by Jean-Yves
MySQL provides a syntax for doing this, see the manual, "4.8.7 mysqlimport".

Alternatively, the easiest way is to grab a GUI such as SQLyog and use that to select the CSV file, state how rows and columns are delimited, and click OK! :)

Posted: Mon Oct 27, 2003 8:35 am
by m3rajk
CSV == Comma Seperated Volume

excel can read these, even write to them