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