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