Yes it indicates line 1 - I have checked to make sure that all rows are in fact tab delimited and that there are no blank trailing lines in the data.
The error: data.txt line 1: expected 2 columns of data but found 1 - keeps being thrown. I have tried both under windows and linux and the same error applies. I have checked the command with a number of delimiters ',', ';', '|' and they all work fine however it is only when I have a tab delimited file that i have problems with. Unfortunately I do not have control on the format of the text file when it arrives. I can't help but think that the separator is not being escaped properly to indicate a tab - I have tried \t, \\t, "\t", '\t' but no luck. Just getting frustrated. - I was originally iterating through the data programatically and using an INSERT query to place the data but for 5 million rows this was taking far too long. Again - any guidance is very much appreciated. C. Griggs, Donald-2 wrote: > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Woodbridge > Sent: Wednesday, July 16, 2008 6:00 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Issuing command for bulk import > > 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. > > ==================== > The command line utility should tell you which line it doesn't like. > Does it always complain about even your first record? > > > This email and any attachments have been scanned for known viruses using > multiple scanners. We believe that this email and any attachments are > virus free, however the recipient must take full responsibility for virus > checking. > This email message is intended for the named recipient only. It may be > privileged and/or confidential. If you are not the named recipient of this > email please notify us immediately and do not copy it or use it for any > purpose, nor disclose its contents to any other person. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Issuing-command-for-bulk-import-tp18496217p18497789.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
