34,838
社区成员




select * from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\Reporttemplate\PPVAPO.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
--先给它加个序号
select identity(int,1,1) as ID,* into #temp from 表
go
select * from #temp where ID>3