lucazav
11/16/2017 - 2:18 PM

Import Excel file as SQL Server table

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$']);