Re: Access Oracle from Excel
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Thu, 31 Mar 2011 17:00:08 +0100
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
Other related posts:
