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/