Re: [sqlite] importing data from file with 3 colums to table with 4 columns

Thanks Monte for your response. I am still pretty new to SQlite, but it looks very similar to what Simon suggested. I think it would work just as well. From my perspective the ideal way to do this would be to specify the columns names the following data in the file is to load into.

Re: [sqlite] importing data from file with 3 colums to table with 4 columns

On 9 July 2010 06:18, wrote: > > > Thank you very much Simon. > > That worked very slick. > > > > Say, is there a way to put all of the SQLite3 commands  I used into a script > and have SQLite3 execute them in the script sequentially? > Yes, several ways: use .read command

Re: [sqlite] importing data from file with 3 colums to table with 4 columns

Thank you very much Simon. That worked very slick. Say, is there a way to put all of the SQLite3 commands  I used into a script and have SQLite3 execute them in the script sequentially? -Chris - Original Message - From: "Simon Davies"

Re: [sqlite] importing data from file with 3 colums to table with 4 columns

On 9 July 2010 00:07, wrote: > > > 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

[sqlite] importing data from file with 3 colums to table with 4 columns

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