I've downloaded data in .csv format from an agency's Web site and want to put it in a sqlite database. I created the table as a .sql file and read that into sqlite. It's fine.
However, when I try to import the csv file sqlite balks: sqlite> .import all-deq-contacts-fixed.csv Permits all-deq-contacts-fixed.csv line 1: expected 25 columns of data but found 29 There are only 25 columns, and I do not see any spurious spaces at the end of the line. Each line in the data to be imported terminates with the last string; all columns are strings because it's a PITA to change two to INTEGER and two to REAL on a file 7400 lines long. I know the error is telling me something I've missed, but I just don't see what that is. Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
