I use 'insert into table1 select * from table2' to copy contents from one table to another when they are in the same database.

But how do I do that if the tables are in different databases. I am using ADO's in VB. Do I need to open both the databases and then use the statement?

Thanks