I would use attach database, and then use an insert select..
Ie. Attach database db2; Insert into table1 select * from db2.table2; Hope this helps... Bob Envision Information Technologies Associate [EMAIL PROTECTED] v. 608.256.5680 f. 608.256.3780 ________________________________ From: Richard Boyd [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 1:06 PM To: sqlite-users@sqlite.org Subject: [sqlite] basic sql question: Is there a way of entering multiple rows in a table? Hi, I know I can create a temporary table and insert them from that or use a for loop in C and get it to update the table one row at a time, but is there a 'nicer' way?? I basically have a string of text which I've obtained from another (remote) Sqlite database which I want to append to the end of an existing table in a separate database. Is there a better way than doing it one row at a time? TIA, Richard.
