Peter, I think you're the perfect candidate for using one of the many sqlite gui admin tools out there. There are lots of them and they all do a good job of getting you off the ground when you are a newcomer to sqlite, but I have to shamelessly promote my own tool, SQLiteAdmin. I think it would have avoided many of your frustrations.
You can download it at www.lcsql.com/sqliteadmin.html. Some functionality is disabled in the demo but you can create a new database from the File menu and import a csv file in the Utilities screen. Pete lcSQL Software <http://www.lcsql.com> On Tue, May 8, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 18 > Date: Mon, 7 May 2012 19:34:19 -0400 > From: "peter korinis" <kori...@earthlink.net> > To: <sqlite-users@sqlite.org> > Subject: Re: [sqlite] is SQLite the right tool to analyze a 44GB file > Message-ID: <000001cd2ca9$ee0c96b0$ca25c410$@earthlink.net> > Content-Type: text/plain; charset="us-ascii" > > I did NOT specify a file name when I started sqlite3 - so I guess all is > lost. I'll have to redo it. > > So then the first thing is to specify the db (file) name - what syntax? I > tried typing a file name (test.db) but error. > > > > pk > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users