Hello all!
I am using an ADO recordset to import data into Excel 2000 from a Win
2003/SQL Server2000 setup. My problem is the SQL string is getting
truncated and is not passed to SQL server 2000 in a complete form. Its cut
off. It appears to cutoff around 185 characters. Is this a setting that
can be reset? Is this an ADO Property that should be set to allow a bigger
SQL statement to be passed to SQL server. Its really weird that it only
takes so many characters, truncates the balance of the statement and then
still tacks the double quotes at the end of the statement? The

Here is the ADO recordset :
rs.Open strSQL, cnnStoredProc, adUseClient, adLockReadOnly

Here is the full SQL statement that is assigned to the strSQL variable that
is initially stored in the variable strSQL. This statement runs in the SQL
analyzer with no problems (variables x, and y with actual values).

SELECT [description],count(t2.Result) as total,t2.Result,t2.Vendor,
t1.[date]from Tblquestions t1 inner join TblResultsQuestion t2 on T1.[id] =
T2.QuestionID where T1.type = 4 and vendor like '" & x & "' and
[description] like '" & y & "' group by [description],Vendor, [date], result
order by [description],Result desc

Here is the actual statement that gets put into the strSQL variable when
passed via the above rs.open statement.

strSQL : "SELECT [description],count(t2.Result) as total,t2.Result,
t2.Vendor, t1.[date] from Tblquestions t1 inner join TblResultsQuestion t2
on T1.[id] = T2.QuestionID where t1.type = 4 and ve"