Read Excel file in SQL Server 2008
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=\\ExcelFilePath\excefilename.xls',
'SELECT * FROM [Sheet1$]')
'Excel 8.0;Database=\\ExcelFilePath\excefilename.xls',
'SELECT * FROM [Sheet1$]')
0 comments: