Re: how to use external data with discoverer

hopehope_123_at_yahoo.com (utkanbir) wrote in message news:<f6c90ebe.0401070511.16d00a0e_at_posting.google.com>...
> Hi gurus ,
>
> Is it possible to use an external data source (such as an excel file)
> with oracle discoverer and combine that data source with an oracle
> table without putting the external data inside the db server? Mu
> customer wants to use its pre-prepared excel or txt files as inputs to
> the discoverer queries. The customer says she can do this thing by
> using business objects, it allows to query an excel file and database
> table together.
>
> Kind Regards,
> hope

http://otn.oracle.com/products/discoverer/htdocs/hints/index.htm and click on How to read flat files and Excel files as data sources into Discoverer

Unless she wants to write to it, then you will have to get the db involved.

jg

--
@home.com is bogus.
Happy birthday David Bowie!