>From: Patrice Olivier-Wilson [mailto:biz@stripped]
>Sent: Sunday, September 27, 2009 10:19 AM
>Subject: Re: Newbie question: importing cvs settings
>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?
[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 happens?
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
>Patrice Olivier-Wilson wrote:
>> 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 was false. It was dependent on how
>> many rows, and I had been using tests with same amount of data.
>> As I said, very beginner level, so thanks for the patience.
>> screenshots at
>> thank you....
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1