sql batch upadates

Hi,
I'm sure there is a method for executing a whole bunch of sql commands in one go to save connection resources, but I can't find details anywhere.

eg. I have code which loops through an array of criteria updating the relevant database record each time. It would be good to save all of the updates to the end so as to avoid so many executions. My current code is:

ids=(1,2,3,4,5,6,7,8,9,10,11,12,13,14) 'to include hundreds of values

for i = 0 to Ubound(ids)
sql= "UPDATE mytable SET mycolumn='value' WHERE id='"&ids(i)&"'"
objconn.execute(sql)
next

Thanks