Excel Add-In for xBase

Build 23.0.8770

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
EmptyStringIsNullTells provider to expose empty strings as null values.
ExcludeFileExtensionsSet to true if file extensions should be excluded from table names.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
OtherThese hidden properties are used only in specific use cases.
SetExactOnMimics beahviour of SET EXACT ON mode in Microsoft OLE DB provider.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

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