Have you tried PRAGMA integrity_check 'ing your DB? Have you tried with a clean DB / new Table?
-----Original Message----- From: Patton, Eric [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 3:59 PM To: 'sqlite-users@sqlite.org' Subject: RE: [sqlite] Problem importing csv file Andre, I receive the same seg-fault if the headers are removed. I had initially tried to import without headers, and added them after the import was unsuccessful. -- Eric Patton [EMAIL PROTECTED] -----Original Message----- From: André Goliath [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 10:44 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Problem importing csv file 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.