>Is there a way to save the entire contents of a datagrid into a adodb.recordset without writing to a database.
>
>ie.just copy the data to a recordset variable

You can create an in-memory (or programmatic) recordset. See http://msdn.microsoft.com/library/techart/midtier.htm#midtier_progrecsets.