SQL将Excel文件导入数据库

--启用Ad Hoc Distributed Queries：
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

select * from  OPENROWSET('MICROSOFT.JET.OLEDB.4.0'  ,

     'Excel 5.0;HDR=YES;DATABASE=d:\我的文档\桌面\ORDERS\EORDERS.xls',sync$) 

--使用完成后，关闭Ad Hoc Distributed Queries：
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0