Comments by Lee Chetwynd (Top 1 by date)

You could put them in an array first and then loop the array, inserting into the table. I dont know if that would be any better.

Or you could hold the sql insert text in a string variable and add to the string on each loop iteration. When its finished you could then execute the sql insert statement using the string variable.