Specifies whether or not simple names should be used for schemas, tables and columns.

Data Type

bool

Default Value

false

Remarks

Microsoft Excel schemas, tables and columns can use special characters in names that are normally not allowed in standard databases. UseSimpleNames makes the driver easier to use with traditional database tools.

Setting UseSimpleNames to true simplifies the names of schemas, tables or columns returned. It also enforces a naming scheme such that only alphanumeric characters and the underscore are valid for the displayed column names.

Any non-alphanumeric characters are converted to underscores.