select * into tab3 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=D:/TDDOWNLOAD/gsEx2.xls',sheet1$)
excel 导入到 ms SqlServer2000
最新推荐文章于 2024-09-26 21:42:53 发布
select * into tab3 from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=D:/TDDOWNLOAD/gsEx2.xls',sheet1$)