Multiple inserts into table

[MarkTweedie]

Hi Everyone,

I'm trying to run a multiple insert into a table on the same connection. The problem is that I only get 19 inserts and on the 20th I get the error message: "ADODB.Command.1 error '800a0e7d' Invalid connection." The previous 19 have all executed perfectly. Any ideas what might be wrong?

Thanks