> > 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? >
I saved your data in a file named "x1.csv" then did this: [EMAIL PROTECTED]:~/sqlite/bld> ./sqlite3 SQLite version 3.3.5 Enter ".help" for instructions sqlite> create table t1(a,b,c); sqlite> .separator , sqlite> .import x1.csv t1 sqlite> select * from t1; 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 sqlite> In other words, I am unable to reproduce your problem. -- D. Richard Hipp <[EMAIL PROTECTED]>
