On 7 Aug 2009, at 4:21am, aerende wrote: > sqlite> .import myfile.csv mydatabasetable > sqlite> .output mydatabasetable.sql
When you look at the .sql file in a text editor, does it make sense ? Does it look like legal SQL ? Does it have all the INSERT commands in ? I would probably try it differently: open the .csv file in a spreadsheet program, and use calculations to convert each line into an INSERT command. Then save that column of commands as a text file and add the CREATE TABLE and other commands to it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
