Microsoft KB Archive/134827

= Microsoft Knowledge Base =

XL5: SQL.REQUEST Help Topic Contains Incorrect Example
Last reviewed: September 12, 1996

Article ID: Q134827

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS
In Microsoft Excel, the SQL.REQUEST Help topic contains an incorrect example in the description about how to concatenate references into the query_text argument. The SQL.REQUEST Help topic contains the following example for using concatenation with cell references:

"SELECT Name FROM Customers WHERE Balance > "'&$A$3' This information is incorrect. The correct reference is:

"SELECT Name FROM Customers WHERE Balance > "&$A$3&""

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0.

MORE INFORMATION
The SQL.REQUEST function connects with an external data source and runs a query from a worksheet. SQL.REQUEST then returns the result as an array.