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_at_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 - 17:42:47 CEST

Original text of this message