RE: Access Oracle from Excel

  • From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
  • To: <JBECKSTROM@xxxxxxxxx>
  • Date: Thu, 31 Mar 2011 10:56:53 -0500

Something to looking into is not using excel at all.  With the
relatively new MODEL clause you can do pretty much any number crunching
you'd do in excel in SQL now. This is a link to docs about it in 10.2
which when I think it came out. 

http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.
htm

 

-----------------------

Ric Van Dyke

Hotsos Enterprises

-----------------------

The 10th Hotsos Symposium 

4-8 March 2012  Start making plans now! 

  

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Thursday, March 31, 2011 11:39 AM
To: oracle-l-freelists; oracle-db-l
Subject: Access Oracle from Excel

 

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: