insert into TTEST(id,Name)
select id,Name from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
posted on 2009-01-11 22:44
Documents 阅读(224)
评论(0) 编辑 收藏 所属分类:
SQL Server