very large String

[maro009]

hi i want to add very large selece statement into a string in vba , how can i do this
the selesct statement has 800 char

when i try to add it to string it addes he first 256 char only
any idea?
thx

 

[TonyJollans]

VBA should not have a problem with this - the most likely culprit is the interface. How, and to what database/application) are you passing the string?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[