import question

[Pam]

This is a continue from a previous question: I have an
employee table on sequel that is done in Access
2003 and want to link to an excel spreadsheet, so that
when the user looks at the records in excel they
cannot delete from the sequel table?
I was told to Import External Data in Excel. I did this
and the only problem: is that you can make changes to
this database. Is 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?

 

[Frank Kabel]

Hi
if you want to prevent changes you have to protect the worksheet.
Automatically updating is possible after reopenening the file or
setting the refresh option accordingly

 

[Pam]

Thanks,

-----Original Message-----
Hi
if you want to prevent changes you have to protect the worksheet.
Automatically updating is possible after reopenening the file or
setting the refresh option accordingly

--
Regards
Frank Kabel
Frankfurt, Germany



.