RE: Access Oracle from Excel

From: TJ Kiernan <tkiernan_at_pti-nps.com>
Date: Thu, 31 Mar 2011 10:56:39 -0500
Message-ID: <0EC85B1F3B2DF8409BF66DC182F495D9858DD0_at_DEEDS.pti-nps.com>

How big is the list and how often are you going to need to do this?

If you're going to need to do this on an ongoing basis and the list may be large, then an external table would work quite nicely. (I'm not sure if .xls will work, so you may need to convert to CSV).

You'll need to predefine the table to include the PO and the additional columns you'll be pulling out of the database first, but then the procedure becomes fairly simple.

1. Place the file in the directory you've configured your external table to use (and name the file as configured)
2. Update the external table joining the external po# = database po#
3. Profit!

The other thing I might try would be linking tables (I know it works in Access, but I don't know about Excel). I like this approach less because linking MS Office to Oracle requires ODBC.

HTH, T. J.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom Sent: Thursday, March 31, 2011 10: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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 31 2011 - 10:56:39 CDT