Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From single cell variables to a single column serie | New Users to Excel | |||
function that returns a list to a single cell | Excel Discussion (Misc queries) | |||
SQL.REQUEST Returns Single Cell | Excel Programming | |||
VBA for the case when web request returns nothing. | Excel Programming | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming |