-----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
