Eichenbaum
New member
- Local time
- Today, 17:05
- Joined
- Jul 22, 2011
- Messages
- 8
Hi,
I'm trying to connect in a excel spreadsheet an Access Query using MS-Query. It works fine but only if the Database is not password protected.
In the menu Data in Excel I choose :
From other Sources > From Microsoft Query, select the database and then prompts a dialog box to input login and password.
The standard login in this box is 'admin'. I write the correct password but always excel returns me 'Not a valid password'. I tried with a blank login name but does not have success.
Anyone have an idea why it does not work?
Many thanks in Advance,
Markus
I'm trying to connect in a excel spreadsheet an Access Query using MS-Query. It works fine but only if the Database is not password protected.
In the menu Data in Excel I choose :
From other Sources > From Microsoft Query, select the database and then prompts a dialog box to input login and password.
The standard login in this box is 'admin'. I write the correct password but always excel returns me 'Not a valid password'. I tried with a blank login name but does not have success.
Anyone have an idea why it does not work?
Many thanks in Advance,
Markus
Last edited: