I am trying to develop a VB application using ADO connecting to a DB2 database that will be run on an AS/400. Our problem is that we have encountered excessive run times when trying to do a lot of inserts to tables using the 'one insert at a time' method. Has anyone developed code that will do bulk inserts (say 50 or 100 at a time) in this type of environment that they would be willing to share with me?

Thanks,
Ron