Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did wrong.)
Jerry Schwartz wrote:
[JS] This is just a shot in the dark, but Excel can be rather surprising when
it puts out a CSV file. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what happ
>-Original Message-
>From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
>Sent: Sunday, September 27, 2009 10:19 AM
>Cc: 'mysql'
>Subject: Re: Newbie question: importing cvs settings
>
>Back again... I have 192 records to import, and tried my extra lin
6, 2009 11:02 AM
To: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using
base Administrator (CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 27 September 2009 15:19
Cc: 'mysql'
Subject: Re: N
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
Yep, typo ...:-(
I did
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using CSV method. The LOAD DATA method
did not enter anything.
My earlier assumption about line 17 w
I assume you mean csv not cvs!
What is the error you get when the import fails? What version of MySQL are
you using? Can you post the output of SHOW CREATE TABLE for the table you
are trying to load the file in to and a sample of the csv which is failing
to load?
Do you get the same error if you
