Should i rs.close and Set rs = Nothing in each loop?

[SjR]

You should close before executing another command, but you don't need to set the recordset to nothing until you've completely finished using it.