"Selection Too Large" Message Using SQLRetrieve Function

ID: Q128407

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)

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."

For more information on the SQLRetrieve macro function, choose the Search button in Visual Basic Help, and type:

SQLRetrieve

Additional query words: 5.00c

Keywords : xlnt
Version : 5.00c
Platform : WINDOWS
Issue type :