copy contents from database

[sriky]

I need to copy contents from one database to another (both Access) and I am using the following statement-

Insert into db1.table1 select * from db2.table2

But my code does'nt work. How do I specify db1 and db2. I tried mentioning the path and also used a cn.open statement (for ADO's), but that does'nt work.

Thanks

[Sky1000]

I believe you need to open a connection and recordset for each database, then transfer the data between the two recordsets, rsdB1 and rsdB2, for example.

Sky1000