On 22 Sep 2014, at 10:25pm, Jungle Boogie <jungleboog...@gmail.com> wrote:
> Actually, none of the fields have the dollar sign, that's my mistake. Can I > tell sqlite pre or post import of the csv that the field is number or will it > always take it as it? See the section on CSV Import in <https://sqlite.org/cli.html> If the table already exists (with that column defined as REAL) when you import, it will use the existing column definitions. If you cannot change the file you are importing then you will get a row with the column names in, which you can, of course, ignore. But it would probably be better to delete the first line if you can. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users