Re: Oracle Data Report to Excel Spreadsheet

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Mon, 10 Jan 2005 15:30:11 -0500

Sanjay Mishra wrote:

>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 
Sanjay, if you have  Oracle client on your PC, you can do it without a 
Excel can use  Oracle's ODBC drivers. Install the ODBC drivers, open Excel,
go to Data->Import External Data->New Dabase Query, fill in the blanks and
then do hakuna matata.

Mladen Gogala
Oracle DBA
Ext. 121


Other related posts: