Knowledge Base

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

Article ID: 190106

Article Last Modified on 10/22/2000

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