I have two identical database - db1 and db2. I want to merge the data form db2 into db1. Using VB6 with ado. I can set and open connections to both databases and open recordsets if needed.
I want to try something like
INSERT INTO db1.table1