How do I link a password protected excel file in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel workbook with a password to open. I need to use it as a
linked table in an Access 2003 database. The error I get is that it cannot
decrypt the file.
 
Hi Janet,

As far as I know, Access's Jet database engine can only link to a
protected workbook if it is already open in Excel.

You can open it manually or write code that launches Excel and opens the
workbook using Excel's Workbooks.Open method, which takes a password
argument.
 
Back
Top