Can I link an Access table to a Password protected Excel Workbook?

[WildlyHarry]

I have an excel workbook that is password protected for security reasons. I
need to be able to link a spreadsheet in that workbook to an access db. I
can create the link but when I try to do anything with the linked table in
access, I get an error that says that access cannot decrypt the file. Is
there anyway to link this spreadhseet without removing the password? Thanks
is advance for you help.

 

[Arvin Meyer [MVP]]

You should be able to read the file without a password, but you can't write
to one without it. If you think about it, that's how it should be. You might
try setting up a dsn on an ODBC connection and supplying the password. Even
better, just import the data into an Access table, instead of linking to it.

 

[WildlyHarry]

Thanks for the suggestion. As for the linked table I do not need to write to
it, just to include some data from it on reports. And it has to remained
linked becasue the excel file is updated daily.