I am trying to build an access database that stores the history from another database.  The other database is live and doesn't store history.  It is a constant export of spreadsheets and it's quite a nightmare.  Is there a way to track changes of a PO Value without having to store the history of every single purchase order?  Can I import a spreadsheet and tell Access to only keep new purchase orders and to change only the ones that has new values and to let me know which ones are new and which ones have changed?  Currently, I am using a "data date" as the export date and using a pivot table with conditional formatting in Excel to find what changed.