MSSQL读取excel

--如果没开启，可以先执行开启
--使用前开启Ad Hoc Distributed Queries：
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure
--使用完成后，关闭Ad Hoc Distributed Queries：
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure

--如果文件不带标题行，将HDR改为NO
select *
from openrowset( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=YES;IMEX=2;
DATABASE=C:/Documents and Settings/cc32031/桌面/Employee_Info.xls', 'select * from [DoradoReport$]' )