Hi!

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

Please help me with this.

Thanks,

Aijun

--
Ai_Jun_Zhan
-----------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...fo&userid=2547
View this thread: http://www.excelforum.com/showthread.php?threadid=39596

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

Aijun

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

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-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.