Looks like i have solved the issue, thanks guys for the help
this did the trick mysql> load data infile '/home/dlubowa/test' into table bush fields terminated by ',' (clients,location,service,PhoneNo,contact,emails); -Z On Thursday 09 December 2004 15:54, David Ziggy Lubowa wrote: > 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]
