Hello,
I have a db tbl with the following schema: _ID integer primary key autoincrement name varchar(40) category varchar(40) recommendation varchar(40) I have a data file I want to import which contains 3 columns worth of data. It looks like this: Barracuda|seafood|No Catfish|seafood|No Caviar|seafood|No Conch|seafood|No Herring(pickled)|seafood|No Lox(smoked salmon)|seafood|No Octopus|seafood|No When I try and import it I get the following error: "line 1: expected 4 columns of data but found 3" Since I obviously don't want to explicitly load data into the _ID column, how do I tell it to put the data from the import file into the 3 remaining columns? Thank you in advance. -Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
