MS ACCESS can be used to compare the data from two tables. This technique offers a solution for those who want to find content differences between two tables in excel, text or other file format. Using SQL Joins, it will show record changes from one table to the other. New records that were added and old records that were deleted can be easily compared. In addition to comparing differences, there is another feature that will link the changes from your source data file.
This can be done by following the steps below:
(1) Open MS ACCESS (Start – All programs – Microsoft Office)
(2) Click File à New à Blank Database
(3) Upload the data/table in MS ACCESS by clicking TABLES à NEW
(4) Choose Link Table if you want to link the changes from your external file table to MS Access database.
(5) Click Queries à New. Then select from the options given. (6) By choosing Design view, you can customize your query by filling up the table and changing the Join properties (View à Join Properties) or using an SQL statement (View à SQL View). The other four query wizard options can also be used.
(7) Click Query à Run. Then save the Query.
(8) You can also match a Query to a table and a Query to a Query.