Is there an "elegant" method of doing this:<BR><BR>1. Open connection #1<BR>2. Open recordset<BR>3. Open connection #2<BR>4. Write recordset to connection #2<BR><BR>The best way I have come up with is to store the recordset into an array, open a new recordset, then iterate through the array to insert new rows to the new recordset. I then do a batchUpdate to commit it to the DB.<BR><BR>Is there a better way to do this?