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

Save flat file output with column delimiters \tab as <file_name>.csv and Excel will it open by default.

JP

On Monday 27 January 2003 13:28, you wrote:
> 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

-- 
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

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).