Can anyone please tell me,How to export report data to Microsoft Word
using Oracle Developer 2k?

---

Clarification of Question by muneerhussaini-ga on 20 May 2003 03:47 PDT

I have a form with 3 buttons as follows
1. Generate Report ( I am calling a report on the button press)
2. Save to Word ( I want the exact output of the report on the screen to be 
   saved as word document with proper formatting as shown on the screen )
3. Save to Excel( I want the exact output of the report on the screen to be 
   saved as Excel file)
 Hope I made my point clear. thanks

Could you elaborate further? I guess you are using Forms and you want
to save all the records you queried and save it in Word? If you are
using Dev2k on Windows, use TEXT_IO built-in and write to a file and
save it with an extension of .doc.
hth
bhogak

Try using DESFORMAT to RTF and save the report output to a file. You
should then be able to open the file using Word. I am not sure about
Excel though.

If you copy your report to your desktop (click and drag), you will be
able to open the file using Excel.  Excel will prompt you to delimit
the report and will allow you to set columns.

May I suggest that you use a Mail Merge in Microsoft Word through the
'Tools' / 'Mail Merge' menu.

After choosing Mail Merge set the current doc as your template, then set
your Access database as your data source by choosing 'Open Data Source' in
the Mail Merge helper.

Add in your merge fields using the 'Insert Merge Fields' then add titles,
lines, tables or whatever.