On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote: > On Wednesday 08 December 2004 05:07, Patrick Sherrill wrote: > > David, > > Please provide the complete LOAD DATA INFILE command you used. > > mysql -e "LOAD DATA INFILE '/home/dlubowa/clients.csv' INTO TABLE bush " > -p test
this is test output that is in my test table, this is how my info is mysql> select * from bush; +----------------------------------------------------+----------+---------+---------+---------+--------+ | clients | location | service | PhoneNo | contact | emails | +----------------------------------------------------+----------+---------+---------+---------+--------+ | | NULL | NULL | NULL | NULL | NULL | | "CRS", "Nsambya", "HSDN 350" , "041-267733 / 077-7 | NULL | NULL | NULL | NULL | NULL | +----------------------------------------------------+----------+---------+---------+---------+--------+ sorry for the distorted info, but basically the " "CRS", "Nsambya", "HSDN 350" , "041-267733 / 077-7 " are all under clients field, Yet the info is supposed to be distributed to all the columns of the table. What could i be doing wrong here. cheers > > > thats what i did ... > > > Pat... > > > > [EMAIL PROTECTED] > > CocoNet Corporation > > SW Florida's First ISP > > > > > > ----- Original Message ----- > > From: "David Ziggy Lubowa" <[EMAIL PROTECTED]> > > To: "Eric Bergen" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Wednesday, December 08, 2004 6:54 PM > > 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]