Hi,
You can link an Excel file to an Access table, meaning the Excel table will always show the actual content of the Access table.

The update in Excel can be done manually (right click + update), automatic at opening of the Excelfile, or every X minute.

If you issue it still open and the above fits your demands, please respond and I will explain more in detail.

Kind regards
Bjorn