| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wen Query Issue | Excel Discussion (Misc queries) | |||
| Query and/or 3D Referencing Issue | Excel Discussion (Misc queries) | |||
| counting characters issue | Excel Worksheet Functions | |||
| ms query xp issue | Excel Programming | |||
| Chart & ms Query issue | Excel Programming | |||
![Ai_Jun_Zhang[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
