xxxxxxxxxx
--OPENROWSET
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml;Database=C:\data\simple.xlsx;', Sheet1$);
--OPENDATASOURCE
SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=C:\data\simple.xlsx;Extended Properties=EXCEL 12.0') [Sheet1$];