gtxy20 wrote: > 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.
Do you have any blank lines? like a trailing blank line at the end of the file? -Steve _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users