Specifies the character used to separate the workbook name and worksheet name in the generated table name.

Data Type

string

Default Value

"_"

Remarks

The separator character is inserted between the workbook and worksheet names when forming the table name.

When IncludeFilePath is set to true, the separator is also used between the file path, workbook name, and worksheet name.

For example:

• If set to "_": MyWorkbook_Sheet1
• If set to "-": MyWorkbook-Sheet1
• If set to "#": MyWorkbook#Sheet1

When IncludeFilePath is enabled:

• If set to "_": Folder_Subfolder_MyWorkbook_Sheet1
• If set to "-": Folder-Subfolder-MyWorkbook-Sheet1