Connection between Excel and Access (1 Viewer)

[p4nny]

Hi

I would like to run some Access queries from Excel and import.
The only issue is the Access database is password protected. The format is .accdb and the encryption is set to legacy.

Many thanks for any help / guidance

 

[Ranman256]

you have the password?

 

[p4nny]

Yes I know the password for the database. thanks for the reply