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
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
]
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
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
- Original Message -
From: Ian Sales [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Patrick Sherrill [EMAIL PROTECTED]
Sent: Thursday, December 09, 2004 9:53 AM
Subject: Re: Excel 2 mysql
David Ziggy Lubowa wrote:
On Thursday 09 December 2004 14:33, David Ziggy Lubowa wrote
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
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
:[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
, 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
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
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
[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
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
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:
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
15 matches
Mail list logo