How to get data from an encrypted 2016 access database in excel 2016

Anonymous
2017-08-24T18:41:33+00:00

I am trying to get data from a 2016 access database into excel 2016.  If I apply no encryption to the access database it's very easy to access tables in excel simply by selecting Data->get-data->from-database->From Microsoft access database then browse to the location of my accdb file.  When I encrypt my access database and follow the same procedure, not surprisingly the connection fails with the error “Not a valid password” as at no stage have I been asked for one.  I would have thought Excel would have just prompted me for the access encryption password, but it does not and as far as I can see there is nowhere to specify an access database password in excel. Is there a simple way to get this working without resorting to VBA scripting?

***Post was moved to the appropriate forum category.***

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2017-08-25T14:02:27+00:00

    I don't know. Good question for an Excel forum.

    Would it help to populate the Excel file from Access using DoCmd.TransferSpreadsheet? Look it up in the Help file.

    Was this answer helpful?

    0 comments