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:
Expand|Select|Wrap|Line Numbers
- INSERT INTO Table01 (Col1,col2,col3)
- SELECT col1,col2,col3
- FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\dbfile.mdb';'Admin';'myPassword',Table03)
"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.