Microsoft.ACE.OLEDB.12.0 does not work

Vote count:

0

you may say that this has been asked before but I tried all the solutions around the web and here and none has resolved my issues.

I'm running the following query:

SELECT * INTO [DB_Pack].[dbo].[Output_POL$]
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
  'Excel 12.0 Xml; HDR=NO;
   Database=T:\Reports\Import\excelfile2.xlsx',
   [Output]);

And I get the following error:

Ad hoc access to OLE DB provider 'Microsoft.ACE.OLEDB.12.0' has been denied. You must access this provider through a linked server.

So far I have tried making the regedit changes as well as following this guide http://ift.tt/19P5xTK

Does anyone have any further suggestions on how this issue can be solved.

asked 30 secs ago

Zak Lewis

1

Microsoft.ACE.OLEDB.12.0 does not work