Inserting DAO.Recordset Into A Table

  • Thread starter Thread starter Robbie Baquiran
  • Start date Start date
R

Robbie Baquiran

Hi All:

How would I go about appending records from a parameter query whose
parameters were specified via the dao.querydef.parameters() method.
I figure I can loop through the entire dao.recordset record by record and
force an insert statement on each row, but that's gotta be the most
inefficient way of going about it.

Any response is appreciated!!

- Robbie
 
well the queries which I would like to append are union queries.. some
reason access isnt accepting the SQL I generate even though MySQL does... so
it's kind of a strange one this is.
 
Back
Top