Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Using a RS to populate an empty table

    Anyone know a fast way to add all recs from a rs to a table....

    better than opening 2 rs and iterating through them using addnew & update :

    do while not rs1.eof

    rs1.addnew
    rs1(1).value = rs2(1).value
    rs1(2).value = rs2(2).value
    rs1(3).value = rs2(3).value
    rs1(4).value = rs2(4).value
    rs1.update

    rs1.movenext
    rs2.movenext

    loop

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I don't know a faster way involving a recordset, but running a parsed query or a parameter query could help speed things up. If the recordset is needed, you can at least get rid of the rs1.movenext line

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •