The .import command doesn't play well with attempts to use tables in schemas other than main:
sqlite> .mode csv sqlite> .import test.csv temp.test Error: no such table: temp.test It creates the table if needed, but fails on the insert part because it tries to execute `INSERT INTO "temp.test" ....` instead of `INSERT INTO "temp"."test" ...`. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users