What do you mean by loop problem? There is no loop in the code shown.

Your code needs to use a where clause in the select so you only get the matching record. As coded if there are any records in the DB then it will update the first record every time and never add a second record.

On another note rs248 is an odd name for a recordset. Please tell me that you are not using 248 different recordsets.