Re: Oracle to Excel? How?
From: Kenneth Melcher <kmelcher_at_rafael.Arco.COM>
Date: Wed, 24 Feb 1993 14:08:35 GMT
Message-ID: <1993Feb24.140835.25289_at_Arco.COM>
Date: Wed, 24 Feb 1993 14:08:35 GMT
Message-ID: <1993Feb24.140835.25289_at_Arco.COM>
In article 730518319_at_otto, dtb_at_otto (David Bath) writes:
>I know Excel comes with Q&E that can hit Oracle tables.
>Does anyone know how to get the data from there into an Excel
>spreadsheet ? Preferaly using Excel macros? Or can I get
>the data straight into excel from SQL*Net ?
>
You can get the data from Q+E into Excel via DDE (Microsoft's
Dynamic Data Exchange) on the PC. You can also write Excel macros
which call Q+E directly, which in turn calls SQL*net.
KRM Received on Wed Feb 24 1993 - 15:08:35 CET