var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: exporting oracle to excel
Can anyone suggest an effective method to transfer data from an Oracle 9i database to Microsoft Excel.
I investigated various methods of doing it but none seem to work quite right.
I cant use a ODBC link direct from excel because the process has to be integrated with Oracle forms so users can perform the transfer.
I have tried using the UTL_FILE package to output a CSV file onto to the local machine. Unfortunately the outputted file does not open correctly in Excel.
I have also written an Oracle report with the DESFORMAT = delimited, which works when I generated the report from developer, but does not work when at run time.
If anyone has any working models for such a transfer I would appreciated some guidance.
did you consider the sylk package available from asktom.oracle.com
you can do it throught the oracle navigator
right click the table to export its data
save it as a .csv
if there's a problem opening it
then it's office problem
you can use the same way back to upload to oracle