摘要： 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 #temp1. 物资清单_不锈钢物品录入drop table 阅读全文