Re: End-user reporting tool

Hi,

[Quoted] SQL*XL updates only the last data you have queried from the database to your spreadsheet. You simply change the values on the spreadsheet and use the Multiple Rows Update feature to reconcile with Oracle.

Updates in Oracle will need to be queried back into Excel. When doing a query, SQL*XL will leave the SQL for the query in a note in the first cell. This can be used to refresh the data. Simply select the cell with the SQL comment and open the Query dialog. SQL*XL will copy the SQL into the dialog.

Hope this answers your question.

Gerrit-Jan Linker

"CoxNet" <chasd1_at_cox.net> wrote in message news:<b7ri8.1812$4H5.284730_at_news1.east.cox.net>...
> Gerrit,
>
> What would the limitations of your product be in regards to updates to
> Oracle and Excel?
>
>
> "Gerrit-Jan Linker" <gjlinker_at_oraxcel.com> wrote in message
> news:a5gtji$mnf$1_at_paris.btinternet.com...
> > SQL*XL is the product you want to have a look at. SQL*XL is an addin for
> > Excel that specialises in making it easy to report Oracle data. Simply
> type
> > your SQL and sit back to see the data flow into your database.
> >
> > Have a look at SQL*XL at www.oraxcel.com
> >
> > --
> > Gerrit-Jan Linker
> > Author of SQL*XL: the addin for Excel to access databases
> > http://www.oraxcel.com
> >
> >
Received on Wed Mar 20 2002 - 14:56:09 CET