How to read excel data directly into SQL server 2005?
Ask by Chris Anderson
Updated 18 Sep 2020
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Source\Addresses.xls',
'SELECT * FROM [Sheet1$]')