>-----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 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? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com > > >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 >> http://biz-comm.com/mysqlprojects/ >> >> thank you.... >> >>> >>> >> >> > > >-- >Patrice Olivier-Wilson >888-385-7217 >http://biz-comm.com > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org