select * from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=d:\d.xls',sheet1$) 转载于:https://www.cnblogs.com/xiaopeng84/archive/2009/07/21/1527619.html