Re: How to speedup inserts via ADO ?

Le 16/02/2010 16:22, Relyea, Mike a écrit :
> A word of caution that I bumped into - passthrough queries have a limit
> on the number of characters they can contain.  I don't remember what
> that limit is off the top of my head but I'd guess somewhere around
> 65000.  If your insert string(s) are very long you may have to split it
> up into more than one passthrough.

Thanks for the tip.
Does it also apply to queries passed directly in VBA via the
connection's "execute" method ?
If that's the case, I might try to use an ADO "command" instead.
But defining the parameters of such a command is even worse than parsing
them in an INSERT string...

--
Arnaud Lesauvage