RE: Access Oracle from Excel

  • From: "Brady, Mark" <Mark.Brady@xxxxxxxxxxxxxxxxx>
  • To: "'jj@xxxxxxxxxx'" <jj@xxxxxxxxxx>, "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>
  • Date: Thu, 31 Mar 2011 13:57:06 -0400

http://www.oraxcel.com/

This is a very good utility that Adds into Excel. I bought a site license for 
my company.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jamey Johnston
Sent: Thursday, March 31, 2011 12:05 PM
To: JBECKSTROM@xxxxxxxxx
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: Access Oracle from Excel

Also, Go to Google and type "Using Oracle Objects for OLE with Automation 
Clients" to find the Oracle Objects for OLE Develope's Guide and look at the 
section on Excel.

Also, you could go Tanel's site (http://tech.e2sn.com/oracle-scripts-and-tools 
and download his PerfSheet.xls for an example of Excel and Oracle.

~ jamey
-----------------------------------
Jamey Johnston

Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:

>Absolutely. I personally would write an Excel function in vba to do that .
>Charles Hoopers blog at hoopercharles.Wordpress.com has many bits of vba
>connecting to oracle on it.
>
>On 31 Mar 2011 16:41, "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx> wrote:
>
> Assuming I have a column of PO numbers in an Excel spreadsheet, is it
>possible to access Oracle for each of those numbers to retrieve additional
>information.  The information retrieved for each PO number would go into
>another Excel cell.  Can this be done?  If so, looking for information on
>how.
>
>
>Jeffrey Beckstrom
>Database Administrator
>Greater Cleveland Regional Transit Authority
>1240 W. 6th Street
>Cleveland, Ohio 44113
m����
�祊�l��?���j
�����
>>> This e-mail and any attachments are confidential, may contain legal, 
>>> professional or other privileged information, and are intended solely for 
>>> the addressee.  If you are not the intended recipient, do not use the 
>>> information in this e-mail in any way, delete this e-mail and notify the 
>>> sender. CEG-IP1

Other related posts: