[sqlite] Re Populating a database from a file

Thanks for the prompt reply. What form should the file take. I've tried enclosing the data for each column in double quotes and separating them with either a comma, tab or space but I get an error "expected 5 columns but only found 1. Using | I get "datatype mismatch" Also when I use .dump does

[sqlite] Populating a database from a file

If I'm using MySQL I can populate a database with "Load data infile '/tmp/data.txt' into table table_1" Is there a similar way of loading data into a sqlite3 database? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org