Online Documentation for Data Import for InterBase/Firebird
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.
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.
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.