Execute SQL against ADO recordset



Having created an ADO recordset, is it possible to then refer to this a a SQL statement? For example, having read the Employees
table in the Northwind database into a recordset, could I then copy this to a table in an Access database using a SQL statement?


.