Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tom for your answer, but I have another problem right now, becasue I
tray to ejecute the commnad with a simple select statement and I received a syntax error message. As a mather of fact, I am not sure if the syntax that I am Using is ok. "Tom Ogilvy" wrote: Have you tried making the argument for the sql string be a reference to multiple cells (continuous block) and broken up your sql string so that each part is less than 155 characters. I haven't tested this, but it seems to me it does work. -- Regards, Tom Ogilvy "Xavier" wrote in message ... The SQL.Request external function in Excel 2003 has an SQL string too short. I need to execute the SQL.Request with SQL strings larger than 512 or more. Is there a way to do it? How can I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
How can I count strings within strings | Excel Worksheet Functions | |||
Finding strings within strings | Excel Programming | |||
Finding strings within strings | Excel Programming |