> sqlite> .import all-deq-contacts-fixed.csv Permits > all-deq-contacts-fixed.csv line 1: expected 25 columns of data but found 29
Could you show us this line 1? Pavel On Tue, Sep 22, 2009 at 5:05 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
