"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
> >
It appears as though your key column has exceeded its numerical limit. Do
you have that column typed large enough to contain the data you are putting
into it? Your database will accept the first out-of-range value and re-size
it to the MAX of that column's datatype (int?). When the second
out-of-r
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 excel file from a remote office, and need