Patrice, Use the utility Tom Kyte has on his site called 'owa_sylk'. It will generate SLK files that Excel opens automatically. We use it for lots of end user reports. See the following link: http://asktom.oracle.com/pls/ask/f?p=4950:8:1962318::NO::F4950_P8_DISPLAYID, F4950_P8_CRITERIA:769425837805,%7Bowa_sylk%7D <http://asktom.oracle.com/pls/ask/f?p=4950:8:1962318::NO::F4950_P8_DISPLAYID ,F4950_P8_CRITERIA:769425837805,%7Bowa_sylk%7D> Greg
-----Original Message----- Sent: Monday, January 27, 2003 8:44 AM To: Multiple recipients of list ORACLE-L 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: [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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net> -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mirsky, Greg 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).
