batch insert from recordset

Results 1 to 2 of 2

Thread: batch insert from recordset

  1. #1
    Join Date
    Dec 1969

    Default batch insert from recordset

    I was wondering if there is a simple way to insert everything in a recordset into a db table? Just push a button and it dumps the contents of the recordset into a table.

  2. #2
    Join Date
    Dec 1969

    Default Where'd the RS come from?

    If it came from a query, then the answer is "Sure."<BR><BR>Just re-run the same query but tack on an INSERT INTO tablename ahead of the SELECT.<BR><BR>

Posting Permissions

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