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

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

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

From: Stephen Bye <stephenbye_at_byedesign.freeserve.co.uk>
Date: Sat, 18 Aug 2001 22:36:20 +0100
Message-ID: <#sP861CKBHA.1592@tkmsftngp04>


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 Sat Aug 18 2001 - 16:36:20 CDT

Original text of this message

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