On 28 August 2013 14:16, <[email protected]> wrote: > OK, now copy the data line several times, and you'll see there are errors > for several lines, unrelated to the final CRLF (which I removed this next > sample). > > -- data -- > "Year","Debt","GDP1","GDP2","RGDP","dRGDP","Infl","debtgdp" > "1833","","49.3275923134","","118.3483703666","","","" > "1833","","49.3275923134","","118.3483703666","","","" > "1833","","49.3275923134","","118.3483703666","","","" > "1833","","49.3275923134","","118.3483703666","","","" > "1833","","49.3275923134","","118.3483703666","","","" > "1833","","49.3275923134","","118.3483703666","","","" > ----------- > > C:\temp>sqlite3.exe > SQLite version 3.8.0 2013-08-26 04:50:08 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .sep , > sqlite> .import data tab > data:3: unescaped " character > data:4: unescaped " character > data:5: unescaped " character > data:6: unescaped " character > data:7: unescaped " character > data:2: expected 8 columns but found 43 - extras ignored > sqlite> >
Agreed. The CR character seems not to be handled properly. Change CRLF to just LF, and the import succeeds. Change CRLF to CR and same failure as above. Regards, Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
