Tom is correct about the break apart.
Two solutions I have found helpful...
Put sections of Query string into a Dim Qry_1, Qry_2 AS
String variable... The add/concatenate the two strings
together when building the query statement...

The second thing to do is put the concatenated String
value into a Cell comment. The you can look at it and
debug it ...





-----Original Message-----
If it is more than 255 characters in length, you need to
break the parts of
it into an array. Use the macro recorder to do an
msquery query (Data=Get
External Data) using a similar long query string and you
will see how the
array is constructed.

--
Regards,
Tom Ogilvy

"madhan " wrote
in message
...
Hi,

I have a problem i have a select statement which is
about 20 odd
lines and i'm trying to retrive data from the database
but the problem
is that it gives me a error. can anyone tell me how to
link a multiline
select statement into one in VB.

thanks


---
Message posted from http://www.ExcelForum.com/



.