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

Thread: export to excel

  1. 12-30-2001, 01:54 AM #1
    hnetscape
    hnetscape is offline Junior Member
    Join Date
    Nov 2001
    Posts
    29

    Exclamation excel format

    Hi,

    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.

    Regards,



    [Edited by hnetscape on 12-30-2001 at 01:01 AM]
    balraj
    Reply With Quote Reply With Quote
  2. 12-31-2001, 09:37 AM #2
    jgmagnus
    jgmagnus is offline Senior Member
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width