Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    43

    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 can’t 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.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    did you consider the sylk package available from asktom.oracle.com

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    hi
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •