Thanks for the update, but the issue I see with this code is that it required a missing field.
What I am looking for are different values in the same field in two tables.
So 2 tables are exactly the same format but there has been some changes made in one table to the data stored in the fields. I need to be able to determine what field level data elements have been changed.
Thanks for any help.
scotthris
Last Activity: Jun 6 '07, 05:06 PM
Joined: Oct 19 '06
Location:
-
Using VBA to compare 2 tables field by field
I have 2 tables that are approx. 16000 record sets and I need to create a program that will compare the 2 tables field by field and create a report that will show the primary key and the record sets that were change in the second file.
I am using Access 2002.
If anyone could provide some example VBA I would greatly appreciate it.
Thanks again -
Comparing two tables in query and highlite the changes
I have two very large tables with over 16000 record sets and I need to compare two of these to determine the differences. Once the differences are identified I need to highlite them and export to Excel format.
Can someone please give me the basic code to start this process as there are 93 fields in each record set?
Thanks for your help
No activity results to display
Leave a comment: