RE: Producing .mdb output from sqlplus or SQL or PL/SQL

From: Weiss, Rick <rweiss_at_state.mt.us>
Date: Fri, 24 Jan 2003 14:09:38 -0800
Message-ID: <F001.0053A26C.20030124140938@fatcity.com>

Patrice:

I have used the data extract function in EXCEL to select data from views and tables in my database using an ODBC connection. I imagine you could do the same thing from within ACCESS as well.

You run the query and it populates the spreadsheet which can then be saved.

Rick Weiss
Oracle DBA (certifiable, but not certified)

-----Original Message-----
Sent: Friday, January 24, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L

I am wondering if it is possible to produce .mdb or .xls format files from inside Oracle.

Can this be done?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
--

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

Author: Weiss, Rick
  INET: rweiss_at_state.mt.us

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 Fri Jan 24 2003 - 16:09:38 CST