I'm looking for a fast-track to avoid spending hours developing my own code. I need to compare records in two database's, then add the unique records from one to the other. Does anybody have bit of code they can share, or parts of code?
Are the fields in each record going to have identical information in them? Is so then you can use a couple of queries to give you what you need. Put the two tables in a query and join them on all the fields in the table.
If however you have address information or other information that are not identical but 'mean' the same then you have another situation and that can be very difficult to determine.