Insert or append data from disconnected recordset

[mmayo]

I have a disconnected recordset from a stored procedure. I know I can loop through the records to populate a table, but is there a way to execute this as a single SQL statement?

For example:

SELECT rsFromSP.Field1, rsFromSP.Field2, rsFromSP.Field3
INTO tLocalTable
FROM rsFromSP;