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


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

Original text of this message