我用的是代码如下:
cn.Open "Provider=MSDASQL.1;Driver={Microsoft dBASE Driver (*.dbf)};SourceType=DBF;DBQ=" & Path & ""
rs.Open "insert into SBK in 'c:\yjszs.mdb' select * from YJSSBK", cn, adOpenDynamic, adLockOptimistic
cn.Open "Provider=MSDASQL.1;Driver={Microsoft dBASE Driver (*.dbf)};SourceType=DBF;DBQ=" & Path & ""
rs.Open "insert into SBK in 'c:\yjszs.mdb' select * from YJSSBK", cn, adOpenDynamic, adLockOptimistic
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货