sqlite error importing csv through command line sqlite error importing csv through command line sqlite sqlite

sqlite error importing csv through command line


Since your separator is only a single character, try using the separator command without quotes around the semicolon. So:

sqlite> .separator ;sqlite> .import sqlite.csv test


You can't import into a table with a primary key you have to import into a temp table first.

See the answer to this SO question


Maybe there's a line break in one of your strings that isn't being properly escaped? So it thinks that the 2nd line ends after "tellus" and then tries to parse the text starting with Magna as the 3rd line, and finds no semicolon delimiters. Can you post a screenshot of what the CSV looks like when opened in textpad?