On Error GoTo ErrShow mstrConnectString = "连接字符串" Rs.MoveFirst
Dim cn As ADODB.Connection, strSQL As String, i As Long Set cn = CreateObject("ADODB.Connection") cn.Open mstrConnectString While Not Rs.EOF strSQL = "INSERT INTO bjds.InvoiceDetail (ID,INVOICEID,DATEUISSUED,AMOUNTCHARGED,RECEIVERNO,INVOICESTATE,FORGERYCODE) " _ ' & "VALUES (0,'" & Rs!InvoiceID & "',To_Date('" & Format(Rs!DATEUISSUED, "YYYYMMDD") & "','YYYYMMDD')," & Rs!AMOUNTCHARGED & ",'" & Rs!ReceiverNo _ ' & "'," & Rs!INVOICESTATE & ",'" & Rs!FORGERYCODE & "')" cn.Execute strSQL Rs.MoveNext Wend Debug.Print Now cn.Close
'原来使用的,速度有些慢!! ' With Rs ' .ActiveConnection = mstrConnectString '& "YY" ' .UpdateBatch ' End With If mblnInMTS Then mobjCTX.SetComplete Exit Sub ----------------------------------------------------------------- 修改如下: on error goto errhandle: with cn begintrans execute (strsql) committrans end with exit sub errhandle: cn.rollbacktrans end sub
mstrConnectString = "连接字符串"
Rs.MoveFirst
Dim cn As ADODB.Connection, strSQL As String, i As Long
Set cn = CreateObject("ADODB.Connection")
cn.Open mstrConnectString
While Not Rs.EOF
strSQL = "INSERT INTO bjds.InvoiceDetail (ID,INVOICEID,DATEUISSUED,AMOUNTCHARGED,RECEIVERNO,INVOICESTATE,FORGERYCODE) " _
' & "VALUES (0,'" & Rs!InvoiceID & "',To_Date('" & Format(Rs!DATEUISSUED, "YYYYMMDD") & "','YYYYMMDD')," & Rs!AMOUNTCHARGED & ",'" & Rs!ReceiverNo _
' & "'," & Rs!INVOICESTATE & ",'" & Rs!FORGERYCODE & "')" cn.Execute strSQL
Rs.MoveNext
Wend
Debug.Print Now
cn.Close
'原来使用的,速度有些慢!!
' With Rs
' .ActiveConnection = mstrConnectString '& "YY"
' .UpdateBatch
' End With
If mblnInMTS Then mobjCTX.SetComplete
Exit Sub
-----------------------------------------------------------------
修改如下:
on error goto errhandle:
with cn
begintrans
execute (strsql)
committrans
end with
exit sub
errhandle:
cn.rollbacktrans
end sub