Sorry 程序拷错了应该是
While Not RST_getdata.EOF
RST_fetch.AddNew
For i = 0 To RST_getdata.Fields.Count-1
RST_fetch.Update RST_getdata.Fields(i).Name, Trim(RST_getdata.Fields(i))
Next i
RST_getdata.MoveNext
While Not RST_getdata.EOF
RST_fetch.AddNew
For i = 0 To RST_getdata.Fields.Count-1
RST_fetch.Update RST_getdata.Fields(i).Name, Trim(RST_getdata.Fields(i))
Next i
RST_getdata.MoveNext
另问一个小问题也是关于导入的: ORACLE ->ACCESS
这次是其它的表,一运行程序就在 RST_getdata.RecordCount报错,说RecordCount方法不存在???????
Dim cnn As New ADODB.connect
Dim rst As New ADODB.recordset
Dim cnnStr As StringcnnStr="User ID=test;Password=test;Data Source=test"
cnn.open cnnStr
rst.open "select jyh,spbm,spmc from xsgkb",cnn
其中,jyh和sxh是表的主键,但我只选了jyh.此SQL语句在SQL PLUS中正常.
[:(