Re: Access Oracle from Excel

From: Jamey Johnston <jj_at_jameyj.com>
Date: Thu, 31 Mar 2011 11:04:37 -0500
Message-ID: <74euh769c1xo03msaeiexun8.1301587477978_at_email.android.com>

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_at_gmail.com> 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_at_gcrta.org> 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

†Ûiÿü0ÁúÞzX¬¶Ê+ƒün– {ú+iÉ^ Received on Thu Mar 31 2011 - 11:04:37 CDT