A better solution might be a web page front end to your database that
the users could use directly to enter the required information.

If you want to do it via Excel then I would use Data / Get External
Data / New Database Query, and in MSQuery I would select * from the
relevant query from the database.

You could then run a macro to refresh the query and protect the data as
necessary.

Feeding data back to Access is not quite so straightforward.
I would construct an INSERT INTO query and execute it via a DAO
connection to the database.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup