views:

18

answers:

0

Hi I get this error when running an OPENROWSET command to import data from an xls spreadsheet into a table:

"Msg 7415, Level 16, State 1, Line 4 Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server."

I've already enabled the AdHocRemoteQueriesEnabled setting under Surface Area Config of Sql Server 2008 facets.

So whats wrong here?!? I am running 32 bit Server by the way as I've read that 64 bit Jet drivers don't exist.

Update: I tried adding the SQL login as a sysadmin, as I read this could also be the reason, however I now get the following error:

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Very fustrating...

related questions