Export Access data to see record updates (Database Compare)
You want to see the changes in values between two versions of an Access database, but how can you do this? You've seen Microsoft Spreadsheet Compare, and you know it can compare values. Maybe you've used Microsoft Database Compare – if you have, you know it's designed to find changes in object design, macros, and VBA code, not value changes. There is a way, however, to use Spreadsheet Compare to spot the changes you're looking for.
By exporting your Access data in both database files – either from a table, if it's exactly what you need, or from query results – to an Excel workbook, you can then run your workbooks through Spreadsheet Compare to see the differences.
Export the Access data to workbooks
-
In Access, open the database containing the "original" or earlier data, and open either the table or the query results that you want in Datasheet view. The following shows a very simple example.
-
Click External Data > Export > Excel. The Export – Excel Spreadsheet wizard starts.
-
Choose the name and destination folder for your new Excel file, and click OK. Then, click Close to close the wizard.
-
Close the database.
-
Open the database that contains the "updated" or later data, and open the table or query results like you did for the original data. In this updated database, "California City" is a new record, and Fresno's high temperature was changed.
-
Run the Export – Excel Spreadsheet wizard in the same way for this database.
Run the comparison in Spreadsheet Compare
-
In Spreadsheet Compare, click Compare Files.
-
Browse to the Excel workbook containing the original data by clicking
next to the Compare box.
-
Browse to the workbook containing the updated data by clicking
next to the To box. -
Click OK to run the comparison.
Understanding the results
We'll zoom in on the results of our simple example, where a record for "California City" was added, and Fresno's temperature changed.
In the right pane, which shows the data from the updated database, row 4 now contains California City and its temperature, which was inserted in the Access table. The entire row is highlighted in green. And Fresno's temperature, in row 5, column B, is also highlighted in green, because it was changed from 107 to 111.
Investment is one of the best ways to achieve financial freedom. For a beginner there are so many challenges you face. It's hard to know how to get started. Trading on the Cryptocurrency market has really been a life changer for me. I almost gave up on crypto at some point not until saw a recommendation on Elon musk successfully success story and I got a proficient trader/broker Mr Bernie Doran , he gave me all the information required to succeed in trading. I made more profit than I could ever imagine. I'm not here to converse much but to share my testimony; I have made total profit returns of $20,500 from an investment of just $2000 within 1 week. Thanks to Mr Bernie I'm really grateful,I have been able to make a great returns trading with his signals and strategies .I urge anyone interested in INVESTMENT to take bold step in investing in the Cryptocurrency Market, he can also help you recover your lost funds, you can reach him on WhatsApp : +1(424) 285-0682 or his Gmail : BERNIEDORANSIGNALS@GMAIL.COM tell him I referred you
ReplyDeleteYou want to see the changes in values between two versions of an Access database, but how can you do this? You've seen Microsoft Spreadsheet Compare, and you know it can compare values. Maybe you've used Microsoft Database Compare – if you have, you know it's designed to find changes in object design, macros, and VBA code, not value changes. There is a way, however, to use Spreadsheet Compare to spot the changes you're looking for.