PathSeparator
Specifies the character that the provider uses to replace file path separators when generating table names.
Data Type
string
Default Value
"_"
Remarks
When this property is set, the connector replaces any directory separators in file paths with the specified character when naming tables.
For example, if a file is located at Test/CSVFiles/Test.csv and this property is set to _, the resulting table name is Test_CSVFiles_Test.csv.
This property is useful for creating valid table names when working with files organized in nested folders.