Comparing 2 tables with ado

I am looking for a function using ADO which opens 2 tables in seperate databases and assigns the data from source "Table A" to destination "Table B" .Both Tables have the same data schema with a unique key(CustomerID),If the customerId exists in the Destination table "Table B"  edit its data .If a record does not exist in destination table "Table B" then it must be added .
Cheers T
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

dhodgeConnect With a Mentor Commented:
Why is the answer rejected?  Too much like work?
The easiest way would be to loop through the source and destination recordsets (make sure they are both ordered using the same key).  When you find a record which exists in tableA but not in tableB add it, if the record exists in both update tableB.

All Courses

From novice to tech pro — start learning today.