SQL语句导入Excel

SELECT * 
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;HDR=YES;imex=1;Database=\\sdc-dev-iis01\f$\wenweicai\DataIntegration.xls',
'SELECT * FROM [ProjectAndIOF$]')

 

SELECT *  FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=f:\wenweicai\DataIntegration.xls', [ProjectAndIOF$])