Microsoft KB Archive/190106

= XL97: "Invalid rows to scan" Error Creating Excel Data Source =

Article ID: 190106

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q190106





SYMPTOMS
When you click OK in the ODBC Microsoft Excel Setup dialog box, you may receive the following error:

Invalid rows to scan.



CAUSE
You receive this error message if the Rows To Scan setting is less than 1 or greater than 16.

NOTE: Even though the ODBC Microsoft Desktop Database Drivers Help topic on "Rows to Scan" states that you can set this value to 0, you can only set it to the values 1 through 16 in the ODBC Microsoft Excel Setup dialog box.



RESOLUTION
To prevent the error from appearing, change the value in the Rows To Scan box to any number between 1 and 16, inclusive.



STATUS
This is by design of Microsoft Excel 97 for Windows.



MORE INFORMATION
For the Microsoft Excel ODBC driver, you may enter any number from 1 to 16 in the Rows To Scan box; the default value will always be 8.

For additional information, please see the following article in the Microsoft Knowledge Base:

189897 XL97: Data Truncated to 255 Characters with Excel ODBC Driver

Additional query words: XL97 query external datasource

Keywords: kbprb KB190106

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.