復制代碼 代碼如下:

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

復制代碼 代碼如下:

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=E:/HaierWeb/MyWeb/Doc/abc.xls;Extended Properties=Excel 8.0')...Sheet1$

復制代碼 代碼如下:

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=E:/HaierWeb/MyWeb/Doc/abc.xls;Extended Properties="Excel 8.0;HDR=YES;IMEX=1;"')...Sheet1$