On Tuesday 07 December 2004 20:02, Eric Bergen wrote: > The easiest way to turn excel into MySQL is to have excel save the > file as a .csv (comma separated values) file and use the mysqlimport > utility or a load data infile query to insert it into a table in
cheers guys, i have managed to change my excel file into a .csv and done a LOAD DATA INFILE and dumped the data in the mysql db the only problem though that all the data is going into one field in the table yet it is comma separated with the exact columns. How can i solve this . All help is highly appreciated. -Z > MySQL. > > -Eric > > > On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa > > <[EMAIL PROTECTED]> wrote: > > Hey guys , > > > > i know this has been discussed but looking through the archives i have > > more less hit a stand still , i have one big excel file which has data i > > would like to extract., Now i am no expert in perl neither am i in php , > > i have looked at some tools like navicat but i dont see where you > > actually start the app , if that is what happens. Any help is highly > > appreciated. > > > > cheers > > > > -Z > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]