Import > Delimited text import > Import decimal separator

Decimal separator in source file

When importing numeric data from a text data source file the decimal separator used in the source file must comply with the current Windows systems settings for decimal separator (Windows Control Panel).

An exception is the ISO formatted TimeStamp/DateTime source field using dot (.) as a decimal separator if including milli Seconds and accepted for import irrespective of the current decimal separator setting.

If not, the Windows systems settings must be temporarily adapted to the decimal separator used in the source file.

After import, the numeric data will automatically reflect the current system settings also when exchanged as whatever Paradox or dBASE format between individual systems with various numeric settings.

If the source file decimal point does not comply, this may not raise import execution errors, as the a dot (.) may simply evaluate as a thousands separator and of comma thousands may simply evaluate as a decimal separator or vice versa.

So, do check the use of numeric separators of source files before importing.