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