David, Please provide the complete LOAD DATA INFILE command you used. 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]
