select * into yy from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;IMEX=1;DATABASE=C:\Documents and Settings\Administrator\桌面\yy2222.xls',sheet2$)
关键问题在于IMEX=1
,'Excel 5.0;HDR=YES;IMEX=1;DATABASE=C:\Documents and Settings\Administrator\桌面\yy2222.xls',sheet2$)
关键问题在于IMEX=1