RE: Oracle to Excel

From: <Steve.Parker_at_lis.co.uk>
Date: Thu, 07 Nov 2002 02:18:26 -0800
Message-ID: <F001.004FD819.20021107021826@fatcity.com>

This is how I do it:

1. Set-up an ODBC data source using either the Oracle or MS ODBC driver.
2. In Excel, use the Date->Get External Data menu option
3. Specify the ODBC driver
4. In the Wizard, select the table columns, where and sort or Untick the box and use MS Query where you can type in your own query using the SQL button
5. The data is returned into the spreadsheet

Steve Parker
E Mail: steve.parker_at_lis.co.uk

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Steve.Parker_at_lis.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 07 2002 - 04:18:26 CST