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.
These options set the separator for the source file to ensure correct import. Make sure that they strongly correspond to the source file data.
Set a character to delimit the decimal parts of the imported numbers.
Set a character to separate the digit groups in the imported numbers.
Set a character to separate the year, month and day parts of date values.
Set a character to separate the hour, minute and second parts of time values.
Set the values as they are represented in the source file for correct recognition.
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.
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.
Set one or more variants of NULL value representation in the imported table, e.g. 'Null'. Use a new line for each additional option.
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.
Skip this step
When you are done, press the Next button to proceed to the next step.