First of all, remove the header line from your CSV. SQLite expects only data, no headers.
-----Original Message----- From: Patton, Eric [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 3:04 PM To: 'sqlite-users@sqlite.org' Subject: [sqlite] Problem importing csv file I can't seem to get an 8MB csv import a comma-separated file into Sqlite 3.3.5. The csv in question contains only three columns of comma-delimited data, with the first line of the file containing the column headings: Time,Easting,Northing 184102229,651807.888839,5165628.749959 184102230,651807.890587,5165628.680512 184102231,651807.890878,5165628.668937 184102232,651807.890587,5165628.680512 184102233,651807.890587,5165628.680512 184102234,651807.890587,5165628.680512 184102235,651807.890296,5165628.692087 184102236,651807.890587,5165628.680512 184102237,651807.892917,5165628.587916 Here's the import syntax I used: $ sqlite3 SQLite version 3.3.5 Enter ".help" for instructions sqlite> sqlite> .separator "," sqlite> sqlite> .import Opilio_2005030_Nav_UTM20_1Sec.csv_test Opilio_2005030_Nav_UTM20_1Sec Segmentation fault $ Any ideas what I'm doing wrong here? ~ Eric.