VBA SQL connection issue

[apj101]

I have some vba come which creates a new querytable. Here is the function

Please Login or Register  to view this content.

the SQLquery needs to get HUGE...the above code works fine when its not too big, but I need to look up info on thousands of customers so my query get huge...then the code fails with the error "Application-defined or object-defined error"
The char length on the query which trigger the error is c40,000 chars
I know the sql query itself is fine.
Any ideas why i cant get this to work?
I tried wrapping SQLQuery in array() and also array("" & SQLQuery & "")...didnt work
thanks everyone

[apj101]

dump...anyone?