Simon Slavin wrote: > On 19 Oct 2017, at 7:38pm, Clemens Ladisch wrote: >> the .import command does not work (and can show misleading error messages) >> if the table name contains special characters: >> >> sqlite> .import test.csv temp.t > > What format is the file "temp.t" in ? UTF-8 ? ASCII ? Some sort of code > page ?
The contents of the file do not matter; just use ".once test.csv", "select 'x';". Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users