Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with SQL.REQUEST (Excel/Oracle)
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
![]() |
![]() |