"Joshua J. Kugler" <[EMAIL PROTECTED]> wrote on 07/08/2004 04:24:41 PM:
> On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like:
> > I was sent an excel file from a remote office, and need to put the
data
> > into a mysql database to be displayed on our web site. I removed a few
> >
Fax to:
07/08/2004 06:35 Subject: problem importing .csv (excel
format) into mysql
On Thursday 08 July 2004 02:35 pm, Chip Wiegand said something like:
> I was sent an excel file from a remote office, and need to put the data
> into a mysql database to be displayed on our web site. I removed a few
> lines of fluff from the excel file and saved it as .csv (using .csv
> (ms-dos)).
try:
lines terminated by '\r\n';
> -Original Message-
> From: Chip Wiegand [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 08, 2004 3:36 PM
> To: [EMAIL PROTECTED]
> Subject: problem importing .csv (excel format) into mysql
>
>
> I was sent an ex
I was sent an excel file from a remote office, and need to put the data
into a mysql database to be displayed on our web site. I removed a few
lines of fluff from the excel file and saved it as .csv (using .csv
(ms-dos)). When I try to import the file it gives me a duplicate entry for
key 1 err
