At 23:42 03/02/2008 +0000, Robert Wishlaw wrote: >Instead of > >.separator "\t" > >try > >.separator '\t'
Thanks for the tip, but I tried that too, with no success: # cat test.csv NULL<TAB>123-4567<TAB>John Doe (Note: I just replaced 09 with <TAB> to show you) # sqlite3 db.sqlite SQLite version 3.5.4 Enter ".help" for instructions sqlite> .schema CREATE TABLE customer (id INTEGER PRIMARY KEY AUTOINCREMENT, tel VARCHAR(32), name VARCHAR(255)); CREATE INDEX index_tel ON customer (tel); sqlite> .separator '\t' sqlite> .import test.csv customer test.csv line 1: expected 3 columns of data but found 1 Gilles. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users