-- 启用：exec sp_configure ‘show advanced options‘,1reconfigureexec sp_configure ‘Ad Hoc Distributed Queries‘,1reconfigureSELECT * FROM OpenDataSource( ‘Microsoft.ACE.OLEDB.12.0‘,‘Data Source="d:\test.xlsx";Extended properties=Excel 12.0‘)...[sheet1$]
sql server OpenDataSource查询excel数据
原文：https://www.cnblogs.com/yclizq/p/12199153.html