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

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 27 Jan 2003 05:44:07 -0800
Message-ID: <F001.0053AEEE.20030127054407@fatcity.com>

Patrice,

You can certainly spool a file that Excel will open automatically. Simply create a tab-delimited output file, and make sure the extension is .xls . Excel will open it and automatically have everything in the correct columns.

You can create a tab-delimited file by selecting the following:

set feedback off
set lines 200
set trimspool on
set pages 1000
spool data.xls

select column_1||chr(9)||column_2||chr(9)||column_3 from any_table;

exit;

I do this all the time.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, January 27, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L

I would like the ability to create a file which, when double-clicked upon, will open in Access or Excel automatically.

(I know that Access can import other formats, I just want it to be automatic for users who don't know / don't want to bother importing files.)

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

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

.mdb files are Microsoft Access database files. Best best is import the data from the database into Access using ODBC connection or to create a flat file. Access can work directly with the flat file (hey Access has been doing this for years, Oracle just got this feature!) or you can import the flat file.

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

.xls is possible ... using owa_sylk package ... (check asktom.oracle.com for more info). no clue what .mdb is ...

Raj

Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
<mailto:BoivinP_at_mar.dfo-mpo.gc.ca> ]
Sent: Friday, January 24, 2003 4: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 <http://www.orafaq.net>
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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).

--

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

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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