Yes, I have tried without transaction and it’s slow. But I think Jean-Yves has pointed me in the right direction. I’ll create all the inserts in a string variable, each terminated by a “;”, and then create the transaction and do the mass insert using SQLExecute.