How to read excel data directly into SQL server 2005?
228012-Aug-2011
Updated on 18-Sep-2020
interview
Home / DeveloperSection / Interviews / How to read excel data directly into SQL server 2005?
hi I am software developer at mindstick software pvt. ltd.
Chris Anderson
12-Aug-2011SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\Source\Addresses.xls',
'SELECT * FROM [Sheet1$]')