Hello, Le 24 juil. 08 à 01:28, none given a écrit : > I then attempt the 3 variations of the statement as such : > sqlite3 test.db ".separator '\t' .import data.csv wc2" > sqlite3 test.db ".separator \t .import data.csv wc2" > sqlite3 test.db ".separator '\t' \n .import data.csv wc2" [snip] > What am I doing wrong?
I think you can enter only one dot command, so use the -separator option. And sqlite has a strange behaviour with \t on command line, you must give a REAL tab to the -separator option. On command line, use Control-v <TAB> to insert a real TAB. The command should look like this : sqlite3 test.db -separator ' ' test.db ".import data.csv wc2" Check http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2008-July/004448.html for how to do it from a program. /schplurtz _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
