Take a look at my SQLiteAdmin tool. It will import csv files with or without headers, export them that way too, plus many features to help create and maintain your schema and browse/edit your data. Avaialble at www.lcsql.com.
Pete lcSQL Software <http://www.lcsql.com> On Sun, Sep 2, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 3 > Date: Sat, 01 Sep 2012 12:19:09 -0700 > From: "joe.fis...@tanguaylab.com" <joe.fis...@tanguaylab.com> > To: sqlite-users@sqlite.org > Subject: [sqlite] How do you load a ".csv" and skip the first line? > Message-ID: <50425fad.4020...@tanguaylab.com> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Is there some way to load a ".csv" file into a SQLite database table > when the first row (record) of the file contains headers? > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users