On 15 Feb 2010, at 4:33pm, Phil Hibbs wrote: > Paul Corke: >> Do you need to read the csv data back in to a sqlite database? If >> not, then the file you've got should be ok. > > Well, what I need to do is import csv files from other sources, this > was just a test to see if there were any gotchas. So I do need to fix > the importing.
The command-line tool is correct as far as it goes in producing CSV files: if you use quotes around text fields, it is correct to double quotes inside those fields. Take a look at the CSVs you're trying to import. Are the text fields delimited by quotes ? If quotes appear in the field, are they doubled ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
