--启用Ad Hoc Distributed Queries:
--exec sp_configure 'show advanced options',1
--reconfigure
--exec sp_configure 'Ad Hoc Distributed Queries',1
--reconfigure
--使用完成后,关闭Ad Hoc Distributed Queries:
--exec sp_configure 'Ad Hoc Distributed Queries',0
--reconfigure
--exec sp_configure 'show advanced options',0
--reconfigure
SELECT * into ddd
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')[Sheet1$]
posted on 2009-12-14 15:26
ju 阅读(210)
评论(0) 编辑 收藏 所属分类:
数据库