SQLite Forum

Issue importing csv file to db
The first missing record is the one at line 11901523 in your input file.

The previous record 11901522 contains a "quoted field" which is not terminated for some number of lines.

There also appear to be many lines containing improperly escaped quotes, and quoted fields that are not terminated.

If you fix your quotes I am quite sure that your "problem" will go away.

(Note that I found this first erroneous record by using the above procedure).