exec sp_configure 'show advanced options', 1;
reconfigure;
exec sp_configure 'Ad Hoc Distributed Queries', 1;
reconfigure


select * from openrowset('Microsoft.ACE.OLEDB.12.0',  'Excel 12.0;Database=C:\Temp\Employees.xlsx;HDR=Yes', 'Select * from [TDSheet$]')

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 7
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".