Select * from OpenRowset ('Microsoft.jet.OleDb.4.0', 'Excel 8.0; HDR = NO; Database = C: /Test.xls' - c: /test.xls is an Excel file name, Sheet1 $) - Sheet1 $ is a work table name $
Or connect Excel Select * from OpenDataSource ('Microsoft.jet.OleDb.4.0', 'data source = "e: /excel/excel1.xls"; user ID = admin; password =; extended profits = excel 5.0') .. [Sheet1 $]
