Hi,
I am having issues running an import from the command line (on a Mac).
When running:
sqlite3 separator '\t' test.db ".import data.csv wc2"
I get the error :
line 1: expected 27 columns of data but found 1
(the file and the table structure both exist).
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"
To no avail...
But, if I create a .sqliterc file containing : .separator \t then the import
works.
Why is it I can successfully import with an sqliterc file, but it fails via the
command line?
As I am running the command from an Xcode NTask, I could really do without the
sqliterc file...
What am I doing wrong?
Tia,
S.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
