That modified version sounds useful. Could you mail it? RBS On May 31, 2013 6:14 PM, "Larry Brasfield" <[email protected]> wrote:
> Bart Smissaert wrote: > >> Importing a. csv file via the. import command of sqlite3.exe. >> As the first line holds the field names I want to skip that. >> There is no problem achieving this in code, but could I do this >> purely via sqlite3 commands? >> > > You could do it easily with a temporary table having an and additional > autoincrement column, but the verbage to then select that table into the > one where you want no header line would be code, IMO. > > I get this functionality with a modified version of the SQLite shell. When > headers are on, it also expects to see them upon .import and does the right > thing, which I take to be interpreting them as column names. > > -- > Larry Brasfield > > ______________________________**_________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
