Re: Oracle access via EXCEL

From: Bill Meahan <wmeahan_at_ef0424.efhd.ford.com>
Date: Fri, 4 Nov 1994 13:18:20
Message-ID: <wmeahan.226.000D4EA6_at_ef0424.efhd.ford.com>


In article <786562889wnr_at_zentor.demon.co.uk> neilw_at_zentor.demon.co.uk (Neil Washbrook) writes:
>Can any one help me with a follow up to this discussion. I understand
>the concepts etc of ODBC. I have a client that is running Oracle on a
>mini and wants access to the data from his PC, however he does not
>want the associated network traffic of carrying out the SQL query on his PC.
>Is there a method of generating an SQL query on the PC, sending it to
>the mini, running it there and extracting the information back into
>something like an Microsoft Access Table to allow him to do local analysis on
>his PC?

This is probably an order of magnitude MORE network traffic!

If you use ODBC in the "passthru" mode, the SQL statement gets snet to the host, and only the result set is returned to the PC. What you are proposing sounds like it would copy the entire table from Oracle to Access (which happens sometimes anyway thanks to Access' low-IQ query engine) to then extract the result set. If your typical result set is smaller than the entire table, you save big time by letting the host do the processing! Plus, you take advantage of the higher-performance of the host to do the actual query processing.

--
Bill Meahan,  Senior Developer  |        wmeahan_at_ef0424.efhd.ford.com 
Electrical & Fuel Handling Division, Ford Motor Company
Opions expressed herein are those of the author and in no way represent
any official statement or opinion of Ford Motor Company
Received on Fri Nov 04 1994 - 13:18:20 CET

Original text of this message