oracle

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Oracle

Oracle

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips


Server loaded in 0.08 secs.