Copy recordset into table

[jsnels]

What's the best way to copy an in memory recordset to an access table if they have the same structure. I know this can be done row by row, but is there a better way. All data in the access tables should be discarded. So after the operation the recordset and table are equal.

 

[PWise]

let us say that you recordset is

Select custid,sum(orderamount) as thismonthorders,month(orderdate)thismonth,year(orderdate)thisyear
from orders
where month(orderdate)= month(date()) and year(orderdate)= year(date()))
group by custid,thismonthorders,thismonth,thisyear

run this code

currentdb.execute
insert into tablename(custid,thismonthorders,thismonth,thisyear)Select custid,sum(orderamount) as thismonthorders,month(orderdate)thismonth,year(orderdate)thisyear
from orders
where month(orderdate)= month(date()) and year(orderdate)= year(date()))
group by custid,thismonthorders,thismonth,thisyear