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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-29 : 10:15:12
|
| Pknmishra writes "I’m trying to run a SQL script accessing 2007 Excel file (*.xlsx).However, it gives me an error below:Server: Msg 7403, Level 16, State 1, Line 40Could not locate registry entry for OLE DB provider 'Microsoft.ACE.OLEDB.12.0'.OLE DB error trace [Non-interface error: Provider not registered.].I installed Office 2007 & now error I am getting is Server: Msg 7399, Level 16, State 1, Line 40OLE DB provider 'Microsoft.ACE.OLEDB.12.0' reported an error. Access denied.OLE DB error trace [OLE/DB Provider 'Microsoft.ACE.OLEDB.12.0' IUnknown::QueryInterface returned 0x80070005: Access denied.].I have SQL 2000 installed on Windows2003 server." |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2007-01-30 : 07:16:52
|
| Based on what you posted, I'm going to go out on a limb and say it's a permissions issue... How about posting the script? And have you checked that the ID that is accessing the file via the script can do so outside of the script? |
 |
|
|
|
|
|
'Microsoft.ACE.OLEDB.12.0' reported an error. Access denied.