Import an Excel file using OPENROWSET and the Microsoft ACE OLEDB provider
IF (OBJECT_ID('tempdb..#data') IS NULL)
SELECT *
INTO #data
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 Xml; Database=Z:\SolidQ\Demo\CustomersClustering\Online Retail.xlsx',
['Online Retail$']);