Possible input new records in Access & update Excel files auto?

[CatherineDiane]

I am trying to set up a simple way to input new records (employees) into the
Access database, and then have Excel files updated to reflect the new
entries. This for other departments to have current files on the employees in
their areas.

It has to be Excel because they do not have Access.

I read this on another post while searching for answers, could someone
expound on this? Does it seem to be what would work in this situation?

 

[Jeanette Cunningham]

Hi CatherineDiane,

I have done this before for govt use.
The excel worksheet uses Get External Data.
The external data is a query in your Access database.
Set up the spreadsheet by going to Get External Data, then navigating to the
query in your Access database with the employees details.
Follow the prompts as excel guides you through the process.
After you have set it up, the worksheet will have a special little toolbar
which will have a button to refresh the worksheet.
When a user refreshes the worksheet, the worksheet is updated with all the
data that is in the query in Access.

Jeanette Cunningham

 

[CatherineDiane]

Sounds perfect! Thanks for your help!!