Does anyone know if there is a method for taking the rows in an array and copying them back into a recordset?

I want to extract rows from a recordset into an array, run some calculations, and then put the results into a third table for storage.

I don't want to lose the original values, so I would not want to update the underlying recordset.

One more thing...If I want to use Access as the database, does this mean that the cursortype must be static? I read something that said Access cursors are on the client, and clientside cursors are always static. Just trying to verify if this is true.

Any ideas/comments on this would be much appreciated. Thanks in advance for your help!


Rachel