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
problem.
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 10 2005 - 14:32:31 CST
