Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL to EXCEL file Question
Lun Wing San wrote:
>
> John Zeigler wrote:
> >
> > I have a company hard copy form that has been duplicated electronically in
> > Excel 7. The information to populate it is in Oracle 7.3.2.3. Is there a
> > way to do this using PL/SQL?
>
> Yes, it can use UTL_FILE to do it. However, I think they used SPOOL in SQL*Plus rather
> than PL/ SQL.
>
Another way would be to use Forms 4.5 and use the DDE package to open and write directly into an Excel Spreadsheet. I have done this and it works pretty slick.
Jerry.
-- ------------------------------------------------------ Jerry Bull, Sr. MTS Phone: 303-624-3073 U S WEST Information Technologies Fax: 303-624-8462 931 14th Street, Suite 920 Denver, CO 80202 Email: gbbull_at_uswest.com ------------------------------------------------------Received on Mon Apr 28 1997 - 00:00:00 CDT