Thanks Jay. Great! This could work... I'm wondering, though if you know whether the limitation below (from sqlite documentation) could be safely circumvented if attaching the source db with an alias name. It seems to work when i try it but I'm concerned that there might be other unknown issues.
"You cannot create a new table with the same name as a table in an attached database, but you can attach a database which contains tables whose names are duplicates of tables in the main database. It is also permissible to attach the same database file multiple times." First open db1 then execute: attach database db2 as mydb2 attach datbase db1 as mydb1 create table db2.table1 as select * from db2.table1 eg: db1 --- table1 table2 db2 --- (no tables) ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag ---- On Tue, 5 Apr 2005, Jay ([EMAIL PROTECTED]) wrote: > > Did you try attach and an insert? > > --- de f <[EMAIL PROTECTED]> wrote: > > I'd like some guidance on the most efficient way to copy a large > > table from one slqite db to another. I'm using from within vb > > with a vc++ sqlite wrapper. > > > > I know that the copy command is no longer available in ver3+ and > > am unsure of how to proceed. > > > > do i need to somehow hook into the sqlite.exe command line util > > for import functionality? > > > > Any help is appreciated. > > > > Thank You > > > > ________________________________________________ > > Get your own "800" number > > Voicemail, fax, email, and a lot more > > http://www.ureach.com/reg/tag > > > > > --------------------------------- > > You a Gamer? If you're near Kansas City, ask me about the Recruits and Conquest conventions. > --------------------------------- > > The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call > http://www.lulu.com/content/77264 > > > > __________________________________ > Yahoo! Messenger > Show us what our next emoticon should look like. Join the fun. > http://www.advision.webevents.yahoo.com/emoticontest > >
