I'm using the following command: sqlite3 -separator , %(dbFile)s ".import %(csvFilePath)s %(tableName)s"
I was moving to sqlite from mysql where I was using the mysql command 'load from file' command. The mysql gives you a good summary as x records loaded, x had warnings, and x had erros. It seems that sqlite just bomb's on the first error it encounters and stops processing the file. Ideally there should be a flag which could tell slqite to either ignore errors or stop on first error I use sqlite3 extensively in my application and want to thank you for such a wonderful tool. VJ
