MSSQL2008R2读取excel 2007数据

exec sp_configure 'show advanced options',1

reconfigure

exec sp_configure 'Ad Hoc Distributed Queries',1

RECONFIGURE

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

SELECT *

FROM

OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=C:\a.xlsx;hdr=yes;imex=1',

[sheet1$])

Go

SELECT *

FROM

OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;Database=C:\a.xlsx;hdr=yes;imex=1',

[sheet2$])

GO

exec sp_configure 'Ad Hoc Distributed Queries',0

reconfigure

exec sp_configure 'show advanced options',0

reconfigure