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_at_tkmsftngp04>
Date: Sat, 18 Aug 2001 22:36:20 +0100
Message-ID: <#sP861CKBHA.1592_at_tkmsftngp04>
[Quoted] 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 - 23:36:20 CEST