On 13 Sep 2010, at 11:53am, Mithun Nair wrote: > Its a comma separated file. > When i try importing it into a SQLite table, i get some errors like "expected > 2 columns of data but found 1". Later i found that importing a comma > separated file into SQlite wont work because a comma is considered as a > delimiter by the the SQLite engine even within a "". Is this true?
This is true. You are right. You might argue that it's a bug. Your options are to use some character other than a comma as your separator character (perhaps tab) or to write your own import application which deals properly with quoted strings. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
