USE master
GO
EXEC sp_configure'show advanced options',1
GO
RECONFIGURE
GO
EXEC sp_MSset_oledb_prop'Microsoft.ACE.OLEDB.16.0','AllowInProcess',1
GO
RECONFIGURE
GO
EXEC sp_MSset_oledb_prop'Microsoft.ACE.OLEDB.16.0','DynamicParameters',1
GO
RECONFIGURE
GO
EXEC sp_configure'Ad Hoc Distributed Queries',1
GO
RECONFIGURE

EXEC sp_addlinkedserver --Excel
@server='e',
@srvproduct='',
@provider='Microsoft.ACE.OLEDB.16.0',
@datasrc='c:\pub\e.xlsx',
@provstr='Excel 12.0'   ---- or @provstr = 'Excel 12.0;IMEX=1;HDR=YES;'

EXEC sp_addlinkedserver  --Access
@server='a',
@provider='Microsoft.ACE.OLEDB.16.0',
@srvproduct='',
@datasrc='c:\pub\a.accdb'

select*from e...Sheet1$
select*from openquery (e,'Select * from [Sheet1$]')
select*from openrowset('Microsoft.ACE.OLEDB.16.0','Excel 12.0;Database=c:\pub\e.xlsx;HDR=Yes','Select * from [Sheet1$]')
insert into openrowset('Microsoft.ACE.OLEDB.16.0','Excel 12.0;Database=D:\Pub\e.xlsx;','SELECT PID,nm FROM [d$]')VALUES (6,'Jim')select*from e...d$
SELECT*FROM OPENROWSET('Microsoft.ACE.OLEDB.16.0','Excel 12.0;Database=d:\pub\e.xlsx',[Sites$])

SELECT a,b,c FROM OPENROWSET('Microsoft.ACE.OLEDB.16.0','Excel 12.0;Database=d:\pub\e.xlsx',[sls$])