Microsoft KB Archive/128407

{|
 * width="100%"|

"Selection Too Large" Message Using SQLRetrieve Function

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0c

-

SYMPTOMS
When you retrieve a large result set using the SQLRetrieve macro function in the version of Microsoft Excel listed above, you may receive the following alert message:

Selection too large. Continue without undo?

If you choose Yes, the SQLRetrieve function will continue to retrieve the result set to the specified destination.

CAUSE
The SQLRetrieve function turns off the suppression of alert messages; therefore, you will receive the alert message stated above.

STATUS
Microsoft has confirmed this to be a problem in the version of Microsoft Excel listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
The SQLRetrieve macro function is contained in the XLODBC.XLA add-in (ODBC Add-In on the Macintosh). Before you use the function, you must establish a reference to the add-in using the References command from the Tools menu. For more information, the syntax for the SQLRetrieve function is shown below:

SQLRetrieve(ConnectionNum, DestinationRef, MaxColumns, MaxRows, _    ColNamesLogical, RowNumsLogical, NamedRngLogical, FetchFirstLogical)