i also found that sometimes request of allocating great number of small
memory pieces may dramaticaly slow down the excel macro execution [as a
allocation goes on, the speed decreases], try to check available memory

just to clear, you may execute the same ado command set from the vbscript
interpreter. vbscript is almost 100% excel vba macro compatible, just test
the problemnatic code segment


"arno" <nospam@invalid je napisao u poruci interesnoj
...
Hello,

So, we have here a problem of Excel and not of the configuration of
databases, servers, odbc, etc., right?

regards

arno