AXISHK
asked on
String size in Excel VBA
I have a string that contains a long SQL structure for retrieving data from SQL Server. Is there a work around solution to have longer string size to contain this long statement ?
Tks
Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
About 2 billion characters. I seriously doubt you're even close to that limit.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The SQL statement is coded in a VBA. Any better way to handle this ?
For string size, it is not limited to 255 chars, correct ?
Tks
For string size, it is not limited to 255 chars, correct ?
Tks
Coding the string in VBA is fine as long as the lines are not too long (use line continuations or string concatenation).
String size isn't limited to 255 chars.
String size isn't limited to 255 chars.
ASKER
Tks
ASKER