日期:2014-05-18 浏览次数:20493 次
Declare @TableVar table (PKId int primary key identity(1,1) ,RYear int not null,BMonth int not null ,EMonth int not null,RMoney Decimal(15,2) not null ) insert into @TableVar (RYear ,BMonth ,EMonth ,RMoney) select * from OpenRowSet('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=D:/test/test20110501.xls', 'select * from [Sheet1$]')