Thread: How to use ADO to issue query that more than 250 characters?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ai_Jun_Zhang[_3_] Ai_Jun_Zhang[_3_] is offline
external usenet poster
  
Posts: 1
Default How to use ADO to issue query that more than 250 characters?

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

Reply With QuoteReply With Quote