pietlinden (12/9/2014)

---

--Excel 2007-2010

SELECT * --INTO #productlist

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0 Xml;HDR=YES;Database=C:\temp\Products.xlsx',

'SELECT * FROM [ProductList$]');