I am looking for a VB6 Add-in/ActiveX/Application that will allow me compare two tables and modify the second based on the first. Tables are the same name, just different databases. Functions like compare, delete fields, add fields, update fields. I will really appreciate anybody's input. Meanwhile I will create my own and post it later, but would like to know if anyone has done such thing in the past.

Thanx
Stan