RE: Oracle Data Report to Excel Spreadsheet

From: William B Ferguson <wbfergus_at_usgs.gov>
Date: Tue, 11 Jan 2005 07:21:27 -0700
Message-ID: <OF461B2E69.0C935230-ON07256F86.004E85F4@usgs.gov>

Not sure of your application requirements, but have you looked at HTML = DB?
It will work with 9i, and you can create a screen (web page) of the = layout
you want, then include the export to CSV or Excel button on the page.

It's a totally cool and slick FREE program from Oracle with all kinds of bells and whistles built-in. You can't get completely sophisticated with it, but it can do a whole lot if you're not to far along on your = project.

Bill Ferguson
U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208

~ Think on a grand scale, start to implement on a small scale ~

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of smishra_97_at_yahoo.com
Sent: Monday, January 10, 2005 12:48 PM
To: oracle-l_at_freelists.org
Subject: Oracle Data Report to Excel Spreadsheet

I had Oracle 9i database and need to convert several reports to Excel Spreadsheet. Is there any procedure that can help. I am planning to use Orace 9iAS Mod Plsql to provide direct report to Excel Spread sheet by call Excel and spreading the data in Columns.

I had seen such kind of report Long time back and so any idea, URL or example is of great help to me=20

TIA
Sanjay

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20 http://mail.yahoo.com=20
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 11 2005 - 08:21:03 CST