Importing Password Protected Excel File in Access

jfrink2

New member
Local time
Today, 04:44
Joined
Mar 3, 2008
Messages
6
Hi All,

I have a macro set up using the TransferSpreadsheet action to import an excel spreadsheet into an access db. I now have a new requirement to password protect this spreadsheet. When I try to import the spreadsheet with password protection activated, I receive the following error msg.

Could not decrypt file. (Error 3161)
You tried to access an encrypted Btrieve or Paradox table, but the password you provided is not correct. Try the operation again and enter the correct password.


Your input is greatly appreciated.

FYI...I'm using Access 2000/2003
 

Users who are viewing this thread

Back
Top Bottom