Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with SQL.REQUEST (Excel/Oracle)

Re: Problem with SQL.REQUEST (Excel/Oracle)

From: Chris <cholmes67_at_sympatico.ca>
Date: Sun, 19 Aug 2001 11:42:47 -0400
Message-ID: <3B7FDE77.EF06C430@sympatico.ca>


Thanks for your help, I will give it a shot

Stephen Bye wrote:

> You will need to first select an area of the spreadsheet to store the result
> data (1 spreadsheet row for each database file record and one spreadsheet
> column for each field in the database record), then enter your SQL.REQUEST
> as an array formula.
>
> "Miguel Camba" <mcambab_at_100mbps.es> wrote in message
> news:3B7ED7C2.CDED4769_at_100mbps.es...
> > Why A1 set to =SQL.REQUEST("dsn=dstest1;uid=sys;pwd=systest";;;"select *
> > from scott.emp") return one cell only (EXCEL 97/2000 with Oracle 8.1)
> >
> > Thanks
> >
Received on Sun Aug 19 2001 - 10:42:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US