How are you doing the extract  in Access?



It all depends on what your HR Database is. Is it an Access database, a SQL
database, Adabas or something on a mainframe?



If you cannot work out a native way of doing it in Excel, you can call an
Access routine from Excel and have it write to an Excel spreadsheet. I would
definitely keep the extraction and the update  processes separate.(Extract to
a new spreadsheet) If something happens during extraction, there will be no
updates to back out and you can just rerun the extraction.