_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › openrowset

  • 64bit 襾語 'Microsoft.ACE.OLEDB.12.0' 螻糾 襦貉 貉危一 焔 給.' 覃讌.. [http]64bit螻糾襯 れ企 /passive 旧 譯手 れ(cmd). (れ 覿手 .)

passive 旧 一危 旧ろ/瑚 企.

sp_configure 'show advanced options',1  
reconfigure  
go

sp_configure 'Ad Hoc Distributed Queries',1  
reconfigure  
go
sp_configure 'show advanced options',0
reconfigure  
go

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.16.0', N'AllowInProcess', 1
GO 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.16.0', N'DynamicParameters', 1
GO 

select *
from openrowset('Microsoft.ACE.OLEDB.16.0', 'Excel 12.0;Database=c:\code\test.xlsx', 'select * from [Sheet1$A2:ZZ]')
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2019-01-16 12:29:52

覓伎瑚 螻 苦 覦覯 谿場願 覓願 蠍 蟲れ 谿場碁. (朱 )