DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export to excel

  1. #1
    Join Date
    Nov 2001

    Exclamation excel format


    How can we send the output of a result to an excel sheet. The output should be from oracle d2k reports, i.e., from d2k reports to excel. We have an option to send to the file, but that will come in text format, like that only I want in excel format. Can some one help me.


    [Edited by hnetscape on 12-30-2001 at 01:01 AM]

  2. #2
    Join Date
    May 2000
    Portsmouth, NH, USA

    Talking comma delimited

    you need to save the file as a .csv file.
    OR a .dat file.

    not sure how you can do this from reports, but it is very easy to do with sql/plus with columns separated with ",".
    Or, TOAD does it fairly easily.

    - Jay

Posting Permissions

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

Click Here to Expand Forum to Full Width