Specify Import Settings
On this wizard page, you can specify required import settings. This page provides access to different settings depending on whether you have selected an Excel Workbook or CSV file.
Import Settings for an Excel Workbook
The following settings are available if an Excel workbook has been selected.
Click Next to proceed to the next wizard page: Select a Worksheet, Table or Named Region.
Import Settings for a CSV file
The following settings are available if a CSV file has been selected.
• Use values of the first rows as field names. If this option is disabled, values of the first row will be imported as data and field names will be generated automatically.
•Skip empty rows - Specifies whether or not to include empty rows to the resulting data source.
•Trim Blanks - Specifies whether or not to delete all leading and trailing empty spaces from each value in the source CSV file.
•Encoding - Specifies the character encoding in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
•Newline type - Specifies the line break type in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
•Value separator - Specifies a character used to separate values in the source CSV file. If the corresponding Detect automatically check box is enabled, this setting's value is automatically determined.
•Culture - Specifies culture information used to import data from the source CSV file. Text Qualifier - Specifies the character that encloses values in the source CSV file.
Click Next to proceed to the next wizard page: Choose Columns.