|
-
Mar 7th, 2001, 11:16 AM
#1
Thread Starter
New Member
I try to update the DB with the contains of rs2.
rs2 as been updated in my "business service" and i want to update the DB
rs2 is a recordset from my table Participant.
Some one can help me ?
Private Sub MAJ_DS()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim sSQL As String
Dim sConnectionString As String
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Set rs2 = New ADODB.Recordset
sConnectionString = cgsConnectionString & " Source=" &
"E:\F1\Data\F1.mdb"
cn.Open sConnectionString
rs.Open "Select * From Participant", cn, adOpenDynamic,
adLockBatchOptimistic
rs2.Open "e:\test.xml"
Set rs = rs2 ??
rs.UpdateBatch ??
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|