Comparing 2 tables with ado

Hello
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
visualbasicAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dhodgeConnect With a Mentor Commented:
Why is the answer rejected?  Too much like work?
0
 
dhodgeCommented:
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.

0
All Courses

From novice to tech pro — start learning today.