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]
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.
Click Here to Expand Forum to Full Width