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 -- //www.freelists.org/webpage/oracle-l