Hi:

I'm writing a function to query a database, using ADODB recordset method. The SQL statement is being truncated at 255 characters.

From reading,I found a VB Guide put out by MS that says you can parse the statement in to smaller chunks, and pass them through as an array, as long as the first element in the array is the connection string.

Has anyone got any examples of this method they could share?

Regards
Mike

Are you using VBA in Excel or VB6 or similar?

If VBA in excel, it the truncation occuring in the .Connection = "" string or in the .CommandText =Array("") string

try this syntax for size...

.CommandText = Array(" text "," Text2 "," text3 "," Text4 ")
I always leave a space at the beginning and end of each array element.

Cheers

Matthew