Hey folks,

I'm in the process of trying to create an "information backup" for a simple Access DB I've made for my office.

Everyone here is worried about Access since it can be a bit unforgiving. They're worried that the DB will either break itself, or an inquisitive user will manage to delete something. I would like to give them some peace of mind by updating a spreadsheet in such a way that new records will be added to the sheet, but if a record were to be deleted it would not be removed from the sheet.

What I have now is a macro in Access that exports each table I need to a single workbook with multiple sheets. The problem here is if I remove a record in access and run the macro again, the corresponding row in Excel is gone.

What I have come up with (in theory only) to solve this is the following:

I would like to have one table that will contain the Access Export data (call this Data Export). This can grow or shrink based on the state of the database.

I would then like to have a second sheet in Excel (call this Data Master) that looks at the first and says if a value in Column A in the "Data Export" sheet does not appear in the "Data Master" sheet, copy that whole row to "Data Master." The field I want to look at is a unique identifier so there should only ever be one with that same value.

My gut tells me this is a VBA/Macro sort of application which is why I've decided to post it here. I have rather limited experience with this, but am not totally unfamiliar with them.

Let me know if you need more information. I will need to repeat this process for several sheets, but once I can do it with one it should just be a matter of changing names and cell references.

Thanks in advance,

hotrod