将Excel导入到数据库脚本

select *

from

OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YSE;IMEX=1;DATABASE=E:\BinCard\UploadFiles\aaaaa.xls',[Sheet1$])

select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
'Excel 5.0;HDR=YES;IMEX=2;DATABASE={Excel文件路径}',
[{Sheet名称}$])

-----------------------------------------------------------SQL读取文本文件

SELECT * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;Database=F:\old;','SELECT * FROM [d1111#txt]')

SELECT * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;HDR=NO;Database=F:\NewFiles1;','SELECT * FROM [C1111#txt]')

-------------------------------------------------SQL Server  读取Excel 2007文件
SELECT * FROM OpenDataSource('Microsoft.ACE.OLEDB.12.0',
'Data Source="e:\人员考核关系模版.xlsx";Extended properties="Excel 12.0;"')...Sheet1$

----------------------------------------------------------------------------- x64系统读取Excel

SELECT * FROM OPENROWSET('MICROSOFT.ACE.OLEDB.12.0','Excel 5.0;HDR=YES;IMEX=2;DATABASE=d:\1.xls',[Sheet1$])