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
ewbie 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-Wilso
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
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greetings:
I have a project for which need to import cvs file
fied 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: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greet
Greetings:
I have a project for which need to import cvs files into db.
I can do so up to a point. The import will only do 16 lines,
consistently. Error is failing at line 17.
Steps:
create table fields in Excel document, where they all match database fields
enter information in several of t
