How to use ADO to issue query that more than 250 characters?

[Ai_Jun_Zhang]

Hi!

I am using ADO to retrieve data from ACCESS DB. However, my sql is more than 250 characters long but the .commandText field in ADODB.Command can only take 250 characters. My question is: with use of ADO, how can I issue query that is longer than 250 characters long?

Please help me with this.

Thanks,

Aijun.

[Patrick Molloy]

write a query in Access then just execute the query from your ADO


"Ai_Jun_Zhang" wrote:

>
> Hi!
>
> I am using ADO to retrieve data from ACCESS DB. However, my sql is more
> than 250 characters long but the .commandText field in ADODB.Command can
> only take 250 characters. My question is: with use of ADO, how can I
> issue query that is longer than 250 characters long?
>
> Please help me with this.
>
> Thanks,
>
> Aijun.
>
>
> --
> Ai_Jun_Zhang
> ------------------------------------------------------------------------
> Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...o&userid=25474
> View this thread: http://www.excelforum.com/showthread...hreadid=395967
>
>

[Dick Kusleika]

Aijun

I just executed a Command with a CommandText that was 412 characters long.

--
**** Kusleika
Excel MVP
Daily Dose of Excel
www.*****-blog.com

Ai_Jun_Zhang wrote:
> Hi!
>
> I am using ADO to retrieve data from ACCESS DB. However, my sql is
> more than 250 characters long but the .commandText field in
> ADODB.Command can only take 250 characters. My question is: with use
> of ADO, how can I issue query that is longer than 250 characters long?
>
> Please help me with this.
>
> Thanks,
>
> Aijun.

[Ai_Jun_Zhang]

**** and Patrick,

Thank you very much for let me know that the limitation for .Commantext is not 250 characters. It works now.

Regards,

Aijun.