I am trying to run the following in SQL Server 2008 - management studio: and I am getting the error as below:
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Extended Properties=Excel 8.0;HDR=Yes;IMEX=1;Database=C:MASTER.xlsx',
'SELECT * FROM [Variable Spreadsheet- Invoicing$]')
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
I have the Access database engine 2010 installed on the server.
How do i fix this?