Excel Function - VBA & Oracle SQL query
From: Rob Weeks <rweeks_at_hotliquid.com>
Date: 1996/06/10
Message-ID: <31BC62B6.58D2_at_hotliquid.com>#1/1
Date: 1996/06/10
Message-ID: <31BC62B6.58D2_at_hotliquid.com>#1/1
I kind of asked this before but....
I have a report that I need to run in Excel that will contain about 90 or so
separate SQL queries to ORACLE. There is a worksheet function in the ODBC addin
that works, but it looks like it has to log into ORACLE each time that it executes
a query. Is there either: 1) a commercial product that will do this (CI-Link has
something that would work if my server ran on Unix instead of NT), or.. 2) has
anyone done anything like this in VBA using either ODBC or Oracle Objects for OLE.
Thanks in advance...
Rob Weeks
rweeks_at_kodak.com
rweeks_at_hotliquid.com
Received on Mon Jun 10 1996 - 00:00:00 CEST