- Select the menu item Tools > Import Data > Import from
Delimited File or the Import from Delimited File button from the
main tool bar
- Select the open connection to use for this data export
- Select whether to import a single table or multiple tables
- Select the Next button to proceed to the next step
- Select the database catalog or schema containing the table(s) to
be imported to
- For a single table import:
- Select the table to be imported from the drop-down list
- Select the desired columns (or all) to be imported from the
selected table
- Reorder the columns as desired using the Move up/down
buttons to match the order the columns appear in the file
- For a multiple table import:
- Select the tables to be imported from the 'Available Tables'
list using the arrow selection buttons
- Alter the order in which each table will be imported using
the Move up/down buttons
- Select the Next button to proceed to the next step
- Select a valid file path or paths for each individual table to be
imported
- Select the Next button to proceed to the next step
- Select the delimiter type as contained within the import file
- Select the action on error for the extraction process
- Select the rollback segment size (commit block) for the
process
- Select whether to attempt to parse date values before inserting
into respective tables
Note: If date values exist and this option is not selected
the system will insert each date values as the relevant CHAR
format to be converted to date/time values by the database upon
record insertion. Please review your specific database product
documentation for the acceptable default date/time syntax.
- Select the date pattern to be applied to each date value (see
date patterns)
- Select whether to trim leading and trailing whitespace from each
individual table column value before insertion
- Select whether to run as a batch process (usually faster for very
large record sets)
- Indicate whether the column names are included on the first row of
the import file(s)
Note: For an individual table import, where the column has
not been selected for import and this column exists within the
import file as denoted by the column name, it is ignored and
NOT inserted
- Select the Next button to begin the data import process
- Monitor the output pane for any errors - use the Stop button to
halt the process at any stage during the run
Note: Data may or may not have been committed to the
database when the Stop button is selected
- Select Finish (or Back to correct errors etc) when the process
has completed
|