98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Oracle
Oracle
Resolved · Low Priority · Version 2003
Jason has attended:
Excel Advanced course
Oracle
Does anyone know a good way to get Oracle reports into Excel?
RE: Oracle
Hi Jason, Thank you for your post, in answer;
First make a report then; in the "File" Menu there is an option to "Generate File", in that select "Delimited". A small box appears with the window title "Delimited Output". In that window, specify the date format you gave in the report, if there is one. Specify numbers and cell wrappers also. Then click "OK". If there are no special formats simply press OK.
Then, it will ask you to type the file name for generating the output.
Next go to "Save As". Type in the window "Select All Files". In file name box give the file name as ".xls" and save it.
Compile and run the report. Then the report will be generated.
In your folder you will see the file name with the name you had saved with .xls type that will contain data of that particular report.
I hope that has helped, best regards Pete
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |