If all else fails - after the import issue DELETE FROM XYZ WHERE ID = 'id' ;
But - yes - adding the "skip=y" and "load=x" parameters (skip the first y rows in the .csv file, and stop after loading x rows) - to the .import utility would be most desirable. On Sat, Sep 1, 2012 at 12:31 PM, Petite Abeille <petite.abei...@gmail.com>wrote: > > On Sep 1, 2012, at 9:19 PM, joe.fis...@tanguaylab.com < > joe.fis...@tanguaylab.com> wrote: > > > Is there some way to load a ".csv" file into a SQLite database table > when the first row (record) of the file contains headers? > > On *nix, any of tail +2, more +2, etc would do. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
