примеры работы с Excel-файлами разных версий при помощи openrowset из TSQL

EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH override
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE WITH override
 
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
 
EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.Jet.OLEDB.4.0',N'AllowInProcess', 1
EXEC master.dbo.sp_msset_oledb_prop N'Microsoft.Jet.OLEDB.4.0',N'DynamicParameters',1
 
SELECT ID, Name, City
FROM openrowset('Microsoft.Jet.OLEDB.4.0','Excel 8.0;HDR=Yes;Database=D:\book.xls',[Sheet1$])
 
SELECT ID, Name, City
FROM openrowset('Microsoft.ACE.OLEDB.12.0',
                'Excel 8.0;HDR=Yes;Database=D:\book.xls;IMEX=1',
                'select * from [Sheet1$]')
 
SELECT ID, Name, City
FROM openrowset('Microsoft.ACE.OLEDB.12.0',
                'Excel 12.0 Xml;HDR=Yes;Database=D:\book.xlsx',
                'select * from [Sheet1$]')