Re: Access Oracle from Excel
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 31 Mar 2011 17:00:08 +0100
Message-ID: <AANLkTi=nW7=tDTT3qEgNoLSrB7s+hGo2rWOQS78hC+DC_at_mail.gmail.com>
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.
Date: Thu, 31 Mar 2011 17:00:08 +0100
Message-ID: <AANLkTi=nW7=tDTT3qEgNoLSrB7s+hGo2rWOQS78hC+DC_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 31 2011 - 11:00:08 CDT