David, In the load data infile command you can specify the delimiter character (see manual). It is a comma in CSV files, but I think it defaults to the TAB character in load data infile. You can specify the delimiter to be comma in the load command.
However, I prefer to export from Excel as TAB separated, as you don't have to mess with the load data command. Also, more importantly, data fields often contain commas which screws everything up, whereas TABS are much less common in Excell data fields. Hope this helps, Andy > -----Original Message----- > From: David Ziggy Lubowa [mailto:[EMAIL PROTECTED] > Sent: 08 December 2004 23:55 > To: Eric Bergen > Cc: [EMAIL PROTECTED] > Subject: Re: Excel 2 mysql > > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
