轻设计 / 轻生活 / 轻日记 / 轻梦想
=== zhoumojianshe ===
© 优特良品&优特建站出品 | Powered by YOUTIY
SqlServer连接Excel进行sql查询
1、安装AccessDatabaseEngine.exe
2、启用advanced options
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
3、查询Excel数据
SELECT * FROM OpenDataSource( 'Microsoft.ACE.OLEDB.12.0',
'Data Source="d:\123.xlsx";User ID=;Password=;Extended properties=Excel 12.0')...[Sheet1$]
4、关闭advanced options
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure
本文由周末简设原创出品，如需转载请注明出处
本文出处：http://www.youtiy.com/detail_605.html
标签云
网页设计
精致慢生活
感悟思语
我的旧年华
加偶微信
