C:\>type k:\data\test.csv "COL1","COL2" "XXXX","YYYY" "XX,X","YYYY"
C:\>sqlite3 k:\db\testdb SQLite version 3.7.9 2011-11-01 00:52:41 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .separator ',' sqlite> sqlite> CREATE TABLE TEST (COL1 CHAR (4), COL2 CHAR (4)); sqlite> sqlite> .import k:\\data\\test.csv TEST Error: k:\data\test.csv line 3: expected 2 columns of data but found 3 ======================= The 1st line is the titles and is accepted The 2nd line has 2 simple character values and is accepted The 3rd line is rejected because sqlite seems to take the comma in the first column as a delimiter thinking there are 3 values in that line while it expects only 2 This used to work in 3.7.7.1. ?????????????????? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
