Would that empCol1.Save be inside or outside of the For Next? Would I save each new record or wait till the end of the loop and save it all at once. I would think depending on how many records there are doing a transaction would be a little faster.  Thanks.