you could use SQL

sSql = "Select Field1, Field2, Field3, Field4, Field5 form Table1"


then build another SQL statment to re-insert

"Insert Into Table2 Values in(myArray1,myArray2,myArray3,myArray4,myArray5)"


myArray are the values from the first ssql statment that have been passed into an Array.


I am sure there is probabally a better clean'er way of doing it, but this should work

SjR would probabally know a better way