Online Documentation for Data Import for SQL Server

Step 5 - Setting base data formats


This step of the wizard provides a number of options for setting base formats for each source data file. The specified format should match the source data representation.

 

Step 4

 

Separators

These options set the separator for the source file to ensure correct import. Make sure that they strongly correspond to the source file data.

 

Decimal

Set a character to delimit the decimal parts of the imported numbers.

Thousand

Set a character to separate the digit groups in the imported numbers.

Date

Set a character to separate the year, month and day parts of date values.

Time

Set a character to separate the hour, minute and second parts of time values.

 

Constants

Set the values as they are represented in the source file for correct recognition.

Boolean True

Set one or more variants of TRUE value representation in the imported table, e.g. 'Yes' or '+'. Use a new line for each additional option.

 

Boolean False

Set one or more variants of FALSE value representation in the imported table, e.g. 'No' or '-'. Use a new line for each additional option.

 

Null Values

Set one or more variants of NULL value representation in the imported table, e.g. 'Null'. Use a new line for each additional option.

 

Date/Time formats

Use these fields to set date and time formats so that they strongly correspond to the source file format for correct processing of data.

For more information refer to the Format specifiers page.

 

NOTE: Date and Time formats only reflect data format view, not separators. Separators must be set in the Separators group above.

 

CheckBox Skip this step

Check this option to skip the current step in the future. To edit the list of skipped steps, use the Skipped Steps group available in the General section of the Preferences dialog.

 

When you are done, press the Next button to proceed to the next step.