hi,

you can link an excel sheet to an access table so that when the excel sheet is updated it updates the access table.
Go to file - get external data - link tables. A wizard will guide you through the process - for more info see help in access and type 'linking spreadsheets'

Cheers

John