Re: Excel to Oracle
From: David Pinkus <dpinkus_at_oracle.com>
Date: Mon, 1 Mar 1993 22:10:03 GMT
Message-ID: <1993Mar1.221003.18521_at_oracle.us.oracle.com>
Date: Mon, 1 Mar 1993 22:10:03 GMT
Message-ID: <1993Mar1.221003.18521_at_oracle.us.oracle.com>
>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 ?
>David T. Bath | Email:dtb_at_otto.bf.rmit.oz.au (131.170.40.10)
>Senior Tech Consultant | Phone: +61 3 347-7511 TZ=AEST-10AEDST-11
>Global Technology Group | 179 Grattan St, Carlton, Vic, 3153, AUSTRALIA
>"The robber of your free will does not exist" - Epictetus
-- There is a new product from Oracle called Oracle Glue that will allow you to access the Oracle database (and in the future any ODBC supported database) from Excel, without the 255 character limit. You can spread your SQL statement over as many cells as you need to and send all of the cells as one block to the Glue driver and then off to Oracle. It works as a Macro function, so you can of course write macros with it as well. For example: =EXECSQL(A12:A20) where a12 through a20 have your sql statement. The value returned into the cell is the Oracle error code, so you can also trap errors. There is also a DDE component of Oracle Glue that relaxes the 255 character limit (now it is 32K), and you can set up HOT LINKS between excel and the DDE component of Glue to have the same dynamic capabilities that Q+E have. Thanks, David Pinkus Oracle CorporationReceived on Mon Mar 01 1993 - 23:10:03 CET