"Selection Too Large" Message Using SQLRetrieve Function

• 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?

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)

REFERENCES

For more information on the References command:

• Search for "References command (Tools menu)" using the Help menu.
• See "Calling Procedures in Another Workbook," in the Visual Basic "User's Guide."

   SQLRetrieve