Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rainclick
Starting Member
1 Post |
 Posted - 2010-12-16 : 05:24:23
|
| In Microsoft SQL 2008I'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,col3FROM 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. |
|
|
|
|
|
Import from a password protected Access DB