sql语句如下select * into Switchrelation from openrowset('Microsoft.Jet.OLEDB.4.0','Excel 5.0;Database="d:\site.xls";User ID=sa;Password=aaaaaa;', 'select * from Sheet2')
sql语句如下select * into Switchrelation from openrowset('Microsoft.Jet.OLEDB.4.0','Excel 5.0;Database="d:\site.xls";User ID=sa;Password=aaaaaa;', 'select * from Sheet2')
from openrowset('Microsoft.Jet.OLEDB.4.0','Excel 5.0;Database=d:\site.xls;',
Sheet2$)
'select * from [Sheet2$] 注意表名写法