SQL.REQUEST Returns Single Cell
 

G'day,

Beginner question...

I have the following command in cell A1 of my EXCEL 2002 worksheet

=SQL.REQUEST("DSN=db_name;UID=db_UID;SERVER=db_SER VER;PWD=db_PWD",A1:B1000,4,"SELECT
SITE.SITE_ID, SITE.NAME FROM SITE",TRUE)

Seems to access information nicely.... but only returns first entry in
database and only in cell A1 (Site_ID) - Nothing in cell B1 which
should be Site_Name)


Assistance greatly appriciated...

Cheers,
Four Legs Good

SQL.REQUEST Returns Single Cell
 

Most likely you did not enter it as an array formula; if you did not do this
then re-enter the formula in the cell but use Ctrl-Shift-Enter instead of
just Enter to enter it into the cell: that is the standard way to tell Excel
you are using an array formula with results that span more than one cell.

"Four_legs_good" wrote:

G'day,

Beginner question...

I have the following command in cell A1 of my EXCEL 2002 worksheet

=SQL.REQUEST("DSN=db_name;UID=db_UID;SERVER=db_SER VER;PWD=db_PWD",A1:B1000,4,"SELECT
SITE.SITE_ID, SITE.NAME FROM SITE",TRUE)

Seems to access information nicely.... but only returns first entry in
database and only in cell A1 (Site_ID) - Nothing in cell B1 which
should be Site_Name)


Assistance greatly appriciated...

Cheers,
Four Legs Good