可否将获得的记录集,用inser into语句重新导入另一张表中,但该记录集包含binary类型的大字段,如果不能用一句语聚实现,插入记录将是很麻烦的,获得记录集来源表与要插入的表分别属于两个ACCESS数据库,也就是用到了两个cnn联接.该怎么实现呢!!!
解决方案 »
- listbox设置为多选的时候,如何得到选中的值
- 谁能帮我设计一下这个串口问题
- 我在vb中用webbrowser控件加载了一个网页,其中我需要先把网页的onkeypress清空,做一些操作,再把onkeypress赋回原值,请问怎么实现?
- 时间格式04/07/05转换成2005-4-7 ,请教,谢。
- vb6的webbrowser控件怎么通过外面的按钮控制它的内容上下滚动
- 通过串口进行无线通信的问题?
- 在什么地方能找到……?
- 急急急!!!!!!word文档怎样正确显示?
- 给个例子,如何用VB6在NT4(Not WinY2K)中做个MTS做组件?
- 我的VB怎麼了?
- 刚才基础版有人问传入窗体,操作数据库表的问题,来,交流一下(反正有段时间不能来了,给大家留点东西)
- 如何在运行时调用一个函数???
Private conn1 As ADODB.Connection
Private rs1 As ADODB.Recordset
Private conn2 As ADODB.Connection
Private rs2 As ADODB.RecordsetPrivate Sub Command3_Click()
Dim dbfilename As String
Dim strsql As String
Dim ConnectString As String
Dim i As Integer
Set conn1 = New ADODB.Connection
dbfilename = "F:\csdn_vb\database\listbox\article1.mdb"
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbfilename & ";Persist Security Info=False;"
conn1.Open ConnectStringSet conn2 = New ADODB.Connection
dbfilename = "F:\csdn_vb\database\listbox\article2.mdb"
ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbfilename & ";Persist Security Info=False;"
conn2.Open ConnectStringSet rs1 = New ADODB.Recordset
Set rs2 = New ADODB.Recordsetstrsql = "select * from mz"
rs1.Open strsql, conn1, 1, 3
rs2.Open strsql, conn2, 1, 3For i = 0 To rs1.RecordCount - 1
rs2.AddNew
rs2.Fields("mc") = rs1.Fields("mc")
rs2.Fields("memo") = rs1.Fields("memo")rs2.Update
rs1.MoveNext
Next
End Sub
Dim cn As ADODB.ConnectionPrivate Sub Form_Load()
Set cn = New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\db1.mdb;" & _
"Persist Security Info=False"
End SubPrivate Sub cmdInto_Click()
Dim Sql As String
Sql = "INSERT INTO [E:\A.mdb].tb_word " & _
"SELECT word From tb_word " & _
"WHERE word_id not in (SELECT word_id from tb_word in 'E:\A.mdb')"
cn.Execute Sql
End Sub
Dim db As New ADODB.Connection
db.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=f:\a.mdb"
db.Open
db.Execute "insert into UserTable in '" & "f:\b.mdb' select * from UserTable"'将a.mdb库中的表UserTable导出到b.mdb库中的表UserTable
MsgBox "成功"
End Sub