I need to execute the SQL.Request with SQL strings larger than
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?
|