ODW

Too bad. Thanks for the info. Another scenario that I want to test is
bringing the recordset over one time at Workbook_Open, then just looping
through it as the function is called. That way the function isn't creating
network traffic. I'll report back if I ever get around to doing any of this
testing.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"onedaywhen" wrote in message
om...
Dick,
You cannot query a recordset as if it were a table, so no, you have to
do the join in either Oracle or Excel (or use ODBC pass through e.g.
linked tables in MS Access). And to get the Oracel table into Excel
you should be able to use Jet's SELECT..INTO syntax to import the data
direct (not using a recorset = faster) but I haven't tested this for
Oracle.

--

"Dick Kusleika" wrote in message
...
Interesting, thanks.

Can I use the recordset from Oracle in a left join without putting it on
a
sheet, thereby eliminating the need to create a new sheet?

If I do create a new sheet with the Oracle rs, why not use array
formulae to
pull the information over - too slow? I'm going to test this one myself,
but
if you know the answer, I'll take it.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.