Import > Delimited text import

Importing delimited text

This is accessed from the Database menu.

Delimited text is data structured with text lines (disregarding long line display word wraps) representing records and fields separated using text delimiters ("some text") and separators (e.g. semicolon).

Benefits

•Universally exchangeable.

•System independent.

•Visually readable.

Drawbacks

•Decimal numbers format must comply with that of the system of the importing computer (if not capable of custom conversion).

•Date and DateTime formats may be misinterpreted during import due to foreign regional formats used.

•Data types not specified except if accompanied by some text schema file specifying the field data types.

•Delimited text not readily suitable for binary data.

To comply with the numbers format (decimal separator) and date format of the source data, you may have to temporarily change the system (Windows) settings to comply with the formatting of the source data.