-- 启用:
exec
sp_configure
'show advanced options'
,1
reconfigure
exec
sp_configure
'Ad Hoc Distributed Queries'
,1
reconfigure
SELECT
*
FROM
OpenDataSource(
'Microsoft.ACE.OLEDB.12.0'
,
'Data Source="d:\test.xlsx";Extended properties=Excel 12.0'
)...[sheet1$]