Re: Forms 5.0 to excel

You can use the TEXT_IO package to write your data to a delimited text file. Then you can use the OLE2 package to read that delimited file into Excel via the Excel object model. In your form, you should have an OLE item to cover the area where you want the excel spreadsheet to be. Then use INITIALIZE_CONTAINER to bring up the excel spreadsheet within your form.

Adrian Klingel
Consultant

Ganapathy Pemmanda wrote:

> I need to transfer data from forms to excel. Basically , what Iam
> supposed to do is when I click on a button in forms it should bring up
> the excel datasheet showing data from the forms(database). How do I do
> this? If u have the code for getting the data can you please e-mail me.
> Can anyone help?
>
> Thanks in advance
> Ganapathy
Received on Fri Jun 26 1998 - 00:00:00 CEST