I'm trying to import from a table of a password protected Ms Access database by using

[Ganesh Kulkarni]

In Microsoft SQL 2005

I'm trying to import from a table of a password protected Microsoft Access database file, by using OPENROWSET command, but it's not working.

here is my code:

INSERT INTO Table01 (Col1,col2,col3)
SELECT col1,col2,col3
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\dbfile.mdb';'Admin';'myPassword',Table03)

and this is a error message after I execute this query:
"OLE DB provider "Microsoft.Jet. OLEDB.4.0" for linked server "(null)" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

Consider that, if I remove the Access database password, this query will work properly (with a (null) password of-course!)

Please somebody can help me?

I will appreciate that so much.