ADO.NET Provider for Microsoft Excel

Build 23.0.8839

RowScanDepth

The maximum number of rows to scan to look for the columns available in a table.

Data Type

int

Default Value

15

Remarks

The columns in a table must be determined by scanning table rows. This value determines the maximum number of rows that will be scanned.

Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly, especially when there is null data.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839