Hi, I the following commands from my application to bulk import data from a tab delimited text file (over 5 million records).
-separator "\t" test.db ".import data.txt testtable" -separator \t test.db ".import data.txt testtable" but I keep getting the following error - expected 2 columns of data but found 1. Now I have checked the data.txt and have confirmed that it is a 2 column tab delimited flat text file. I am thinking that the separator is not being properly recognized because I parsed some sample data as semi-colon delimted and used the following with no problems. -separator ; test.db ".import data.txt testtable" Any help is very much appreciated. Celeste. -- View this message in context: http://www.nabble.com/Issuing-command-for-bulk-import-tp18496217p18496217.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
