Inserting DAO.Recordset Into A Table

  • Thread starter Robbie Baquiran
  • 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
 
R

Robbie Baquiran

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I read in a record / row from a table. 5
Record is deleted error when inserting into a table 1
Inserting form values into a table 4
insert values into table 12
RunSQL statement in DAO loop 5
Insert data into a table 2
Loop through a record set to change a currency field based on average difference of two fields 0
Curious Reaction to subform SQL statement 11

Top