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.

Reply via email to