Import Wizard, The File Name Options Page

ImportWizard FileNameOptionsPage92.png

Contents

Rename

Auto

Automatically rename worksheets according to the import mode and filenames

Worksheet with File Name

Rename worksheet with file name upon import.

Worksheet with variable

Choose a variable to rename the worksheet from the drop-down list which is extracted from the file header in Variable Extraction page.

Workbook with File Name

Set workbook long name with filename upon import.

Workbook with variable

Choose a variable to rename the workbook from the drop-down list which is extracted from the file header in Variable Extraction page.

Rename Long Name for Book only

Only rename the Long Name for Worksheet and maintain the Short name as default.

Include Path When Renaming Workbook

If this checkbox is selected, full pathname is used to rename the target workbook.

Append

File Name to Workbook Comments

Store the import file name with the workbook Comments (accessible in both the Comments section of the Window Properties dialog box and the Workbook Organizer).

File Name to Column Comments

Store the import file name with the column Comments (accessible in both the Comments section of the column's Properties dialog box and the Comments row of the worksheet).

Include Path When Appending File Name

Store the full pathname with the workbook and worksheet column Comments.

Note: This page will not show, when choose User-Defined as Data Type in the Source page