copy recordset to table

[clive2002]

I'm running a stored procedure on a remote sql server to populate an ADO recordset in access VBA, how do copy that recordset to a table without looping through the recordset.

In excel i could just use copyfromrecordset to paste into a worksheet, but i can't work out how to do something this fast and simple in access.

Thanks
Clive