Patrice, Can you post the output of SHOW CREATE TABLE for the table you are having difficulty inserting into? Without knowing the table structure its very difficult to work out why your data load is failing.
Regards John Daisley MySQL & Cognos Contractor Certified MySQL 5 Database 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: 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? 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=john.dais...@butterflysystems.co.uk No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.113/2396 - Release Date: 09/26/09 05:51:00 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org