Re: Oracle to excel at server side

Hi Matthias,

Thanks for your prompt reply!

I think I should provide details information for my situation.

We use developer 2000 (i.e. client/server model) and OO4O to build forms and reports in our system before. With OO4O, we can extract data from Oracle database to Excel and update data from Excel to Oracle.

Now, we want to use developer 6i to deploy forms and reports on the web (i.e. 3-tier model). We are seeking for some tools/methods to replace OO4O.

Do there any solution for this?

For your first suggestion, it can only extract data from Oracle database to Excel, but can't update data from Excel (user's machine) to Oracle.

For your second suggestion, is it possible for 3-tier model?

Ada

"Huebner, Matthias" <matthias.huebner_at_verkehrsberatung.net> wrote in message news:<3c9f110a$0$27804$626a54ce_at_news.free.fr>...
> Salut Ada,
>
> "Ada" <ada106_at_yahoo.com> schrieb im Newsbeitrag
> news:6bd047ec.0203242010.b58ed20_at_posting.google.com...
> > Hi,
> >
> > I want to place Oracle data in an excel worksheet through programming
> > at Solaris (server side). Has anyone a solution for this?
> >
>
> perhaps you may use StarOffice / OpenOffice at Solaris side to read the Data
> directly from your Oracle Database.
>
> then just save as Excel File if available.
>
> other way: connect a windows client to your host db, read the data via odbc
> directly to excel. Save in excel file format.
>
> Matthias
> > Thanks for your help.
> >
> > Ada
Received on Mon Mar 25 2002 - 20:37:05 CST