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 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]