Oracle

The UK's most regular instructor-led training courses.
Training information: excel vba courses · Excel/courses/london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Oracle

Jason has attended:
Excel Advanced course

by - delegate Jason [1 post] (2008 May 6 Tue, 17:02) Reply

Does anyone know a good way to get Oracle reports into Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course				List price £225
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 May 19 Mon	Bloomsbury	0	FULL
2003/XP	2008 May 20 Tue	Tooting	0	FULL
2003/XP	2008 May 20 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 May 22 Thu	Bloomsbury	7	book now	£188	£215
2003/XP	2008 May 29 Thu	Southwark	4	book now	£207	£215
2003/XP	2008 Jun 3 Tue	Bayswater	5	book now	£198	£215
Full Schedule: See all 169 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Oracle

by - trainer Pete platinum contributer [571 posts] (2008 May 8 Thu, 20:35) Reply

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

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training

Please browse our web site to find out more about
excel vba courses and other Microsoft training courses.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application

Main information pages

Oracle

Related articles

Excel tip:

Entering text in Multiple Worksheets