How to import data from a password protected Access DB into Excel.

G

Guest

Hi!,,, this is my situation. I have a user level password protected Access
Database and an Excel spreadsheet in which I need to load a query from the DB.
I am following these steps in excel: Data - Import External Data - Import
Data. But when I select the .mdb I want to import data from, and I fill the
fields user name and password, this happen with two different scenarios:

1- If the test connection button is pressed, the error message is "Test
connection failed because of an error in initializing provider. Cannot start
your application. The workgroup information file is missing or opened
exlucsively by another user." Well, I have a workgroup file, but don't know
how to load it during the import process.

2- If I simply press Ok, a second window appears with the legend "Please
enter MS JET OLE DB Initialization Information", I leave the fields with the
default data (the field "Provider String" is blank by defult) and press Ok,
then nothing happens, nor error message nor data imported.

If somebody has a suggestion, it would be highly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
How to import external data into excel? 2
How do I import data into Excel from Bloomberg using Excel 2007? 1
Baffled on how to import contact list from Excel into Outlook..... 1
Exporting data with vba from Excel to an Access 2007 db with password 8
How do I import data from a text file into Excel 2003 2
Cannot open password protected Access DB 7

Top