Re: Excel 2 mysql

2004-12-09 Thread Patrick Sherrill
;s First ISP there are just two issues that I would look at if his solution - Original Message - From: "Ian Sales" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; "Patrick Sherrill" <[EMAIL PROTECTED]> Sent: Thursday, December 09, 200

Re: Excel 2 mysql

2004-12-09 Thread Ian Sales
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

Re: Excel 2 mysql

2004-12-09 Thread David Ziggy Lubowa
ed 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 Fir

Re: Excel 2 mysql

2004-12-09 Thread David Ziggy Lubowa
EMAIL PROTECTED] > > CocoNet Corporation > > SW Florida's First ISP > > > > > > - Original Message - > > From: "David Ziggy Lubowa" <[EMAIL PROTECTED]> > > To: "Eric Bergen" <[EMAIL PROTECTED]> > > Cc: <[EMAIL

Re: Excel 2 mysql

2004-12-09 Thread David Ziggy Lubowa
IL 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: Wednes

Re: Excel 2 mysql

2004-12-08 Thread Ian Sales
David Ziggy Lubowa wrote: 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

Re: Excel 2 mysql

2004-12-08 Thread Patrick Sherrill
: <[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

RE: Excel 2 mysql

2004-12-08 Thread Andy Eastham
owa [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 > > fil

Re: Excel 2 mysql

2004-12-08 Thread David Ziggy Lubowa
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

Re: Excel 2 mysql

2004-12-08 Thread Adam
Ziggy, I'm not sure what you need help with. If you want to get data into MySQL from Excel, consider saving the data (I assume it is a table) as a CSV then using the LOAD DATA command to bring the data into a temporary table in MySQL. Take a look at the command in the help pages. Regards, Adam

Re: Excel 2 mysql

2004-12-07 Thread Mukasa Assey Alfred
>From Excel, save the file as a CSV (comma separated values) use either mysql load data infile in an insert query or use phpmyadmin to import the csv into a table in your database. Regards Assey On Tue, 7 Dec 2004, David Ziggy Lubowa wrote: > > Hey guys , > > i know this has been discussed but l

Re: Excel 2 mysql

2004-12-07 Thread Eric Bergen
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 MySQL. -Eric On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa <[EMAIL PROTECTED]> wrote: >

Re: Excel 2 mysql

2004-12-07 Thread Ian Sales
Jay Blanchard wrote: [snip] 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

RE: Excel 2 mysql

2004-12-07 Thread Jay Blanchard
[snip] 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 actual

Excel 2 mysql

2004-12-07 Thread David Ziggy Lubowa
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