Here's a hack solution in Windows OS. more +1 test.csv > parsed.csv sqlite3.exe test.db .separator , .import parsed.csv ld_assay
-------- Original Message -------- Subject: How do you load a ".csv" and skip the first line? Date: Sat, 01 Sep 2012 12:19:09 -0700 From: joe.fis...@tanguaylab.com <joe.fis...@tanguaylab.com> To: sqlite-users@sqlite.org Is there some way to load a ".csv" file into a SQLite database table when the first row (record) of the file contains headers? This does not work? ---------------------------------------------- .separator , .import test.csv ld_assay Here's my database / table: CREATE TABLE [ld_assay] ( [id] INTEGER PRIMARY KEY, [barcode_id] NCHAR(9), [light] BOOLEAN, [bpm] REAL); Here's my "test.csv": id,barcode_id,light,bpm 1,000002455,1,180.2 2,000002455,1,168.3 3,000002455,1,189.4 ---------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
