sqlserver 直接查询excel

select identity(int, 1, 1) rownum,*
  into #temp
  from OpenRowSet('Microsoft.Jet.OLEDB.4.0',
                  'Excel 8.0;IMEX=1;Database=D:work_数创客户网球设计餐娱物资清单杯子.xls',
                  'select  * from [Sheet1$] ');

select F2, f3, f4, f5 from #temp where rownum > 1;
drop table #temp