> Did this:
> sqlite3 test2.db
> create Table T (A, B, C );
> .separator ,
> .import 'sqtest2.txt' T
> It looks like it working, but the file size is still
> 4K and not 170 Megs.
> Please note:
> I exported this database as a Tab delimiter file,
> then as a Comma, delimiter file...
> ** Got it to import, however it only imports the first record
it is likely that your line endings are Mac (you are on a Mac, iirc).
Open the tab file in a text editor such as BBEdit (or Textwrangler --
free from Barebones) and change the line endings to Unix. Then try
> sqlite> select * from T;
> There's a few more hundred thousands.....
> is there suppose to be some kinda of loop statement
> like repeat again..