SQL 2008 x64读取excel 2007
摘要:EXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'AllowInProcess' , 1GOEXEC master . dbo. sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0' , N'DynamicParameters' , 1--上面两句要先运行一下就可以了select * from OpenRowSet('Microsoft.ACE.OLEDB.12.0', 'E
阅读全文
posted @
2011-07-27 11:19
lock
阅读(301)
推荐(0)