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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users