View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
xavier xavier is offline
external usenet poster
 
Posts: 21
Default 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?