link access to excel

P

Pam

I have an employee table on sequel that is done in Access
2003 and want to link to an excel spreadsheet for a user
that is familiar with excel over access. Is there an easy
way to link this and keep the excel records updated so
that when the user looks at the records in excel they
cannot delete from the sequel table?
 
P

Pam

I have tried the Import External Data in Excel. The only
problem I don't understand is that you can make changes to
this database. If there any way to import this to excel
and not allow for changes but allow the user to filter out
information? Also will my excel spreadsheet update
automatically when the access db is updated?
 
Top