--No space in excel filename and sheet name
exec ('sp_configure ''show advanced options'', 1')
exec ('reconfigure')
exec ('sp_configure ''Ad Hoc Distributed Queries'', 1')
exec ('reconfigure')
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1
GO
SELECT *
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=C:\file_name.xlsx;Extended Properties=Excel 8.0')...[Report1$]
Wednesday, December 8, 2010
Subscribe to:
Posts (Atom)