SELECT * FROM OPENROWSET('Microsoft.JET.OLEDB.4.0', 'Excel 8.0;Database=C:\yourexcelfilename.xls', 'SELECT * FROM [Sheet1$A3:A53]') --or with selected cell area: SELECT * FROM OPENROWSET('Microsoft.JET.OLEDB.4.0', 'Excel 8.0;Database=C:\yourexcelfilename.xls', 'SELECT * FROM [Sheet1$A2:B5]')
