is there a vba query string length limit and a way to overcome this issue?

Posted by datatoo on Stack Overflow See other posts from Stack Overflow or by datatoo
Published on 2010-03-30T03:00:03Z Indexed on 2010/03/30 6:43 UTC
Read the original article Hit count: 528

Filed under:
|
|
|

I am trying to combine multiple audit tables, and then filter the results into an excel sheet. The Union All and parameters make the query in excess of 1200 characters. It appears the string is truncated when running this. What recommendations can anyone make. I have no control over the database structure and am only reading foxpro free tables.

Thanks for suggestions

© Stack Overflow or respective owner

is there a vba query string length limit and a way to overcome this issue?

Posted by datatoo on Super User See other posts from Super User or by datatoo
Published on 2010-03-30T03:00:03Z Indexed on 2010/03/30 3:03 UTC
Read the original article Hit count: 528

Filed under:
|
|
|

I am trying to combine multiple audit tables, and then filter the results into an excel sheet. The Union All and parameters make the query in excess of 1200 characters. It appears the string is truncated when running this. What recommendations can anyone make. I have no control over the database structure and am only reading foxpro free tables.

Thanks for suggestions

© Super User or respective owner

Related posts about vba

Related posts about excel