Access
The details below are displayed when the "Delimited ASCII files" option has been selected in the first list in the data source selection window of the Data copy tool.
This option is used to read data from delimited ASCII files (*.CSV format).
Data entry
File directory
Directory containing the data files.
Enter the full path or click the Browse button to display a Windows system dialog box that lets you select a directory.
Mandatory entry.
Filter
File display filter.
Default: " *.del ".
Lists
Field delimiter
Character used to separate fields in the file.
String delimiter
Character used to separate string type values in the file.
Encoding
Source file encoding (Ansi, Ascii or UTF-8).
Decimal symbol
Character used to represent the decimal point in numerical values.
Check boxes
Insert NULL values for unspecified fields
If this box is checked, a "null" value will be inserted into the database for any columns that were not specified in the file (or returned a conversion error); otherwise, the default value for the type will be inserted.
Default: Checked.
Buttons
Browse
This button opens a Windows system box that lets you select a directory.