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: [EMAIL PROTECTED] > > > -----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:[EMAIL PROTECTED]> ] > 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: [EMAIL PROTECTED] -- Pruner Jan [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).