Using pass-through queries you can execute the oracle sql directlr o
the Oracle server.

I can't test it at the moment but from memory you cannot format a P
SQl and expect it to execute but if it is a stored procedure on th
Oracle database you can execute it using a pass-through.

My usual plan is to model and test using access (including th
pass-through elements) as this just operates as a front end to dat
objects and then code it in Excel.

Hope this helps

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=50769