copying array to table (reverse of getrows?)
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!