Importing Data from Delimited Files


The Import from Delimited File feature allows for the insertion of data from one or more delimited text files into selected database tables.
  1. Select the menu item Tools > Import Data > Import from Delimited File or the Import from Delimited File button from the main tool bar
  2. Select the open connection to use for this data export
  3. Select whether to import a single table or multiple tables
  4. Select the Next button to proceed to the next step
  5. Select the database catalog or schema containing the table(s) to be imported to
  6. For a single table import:
    1. Select the table to be imported from the drop-down list
    2. Select the desired columns (or all) to be imported from the selected table
    3. Reorder the columns as desired using the Move up/down buttons to match the order the columns appear in the file
  7. For a multiple table import:
    1. Select the tables to be imported from the 'Available Tables' list using the arrow selection buttons
    2. Alter the order in which each table will be imported using the Move up/down buttons
  8. Select the Next button to proceed to the next step
  9. Select a valid file path or paths for each individual table to be imported
  10. Select the Next button to proceed to the next step
  11. Select the delimiter type as contained within the import file
  12. Select the action on error for the extraction process
  13. Select the rollback segment size (commit block) for the process
  14. 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.
    1. Select the date pattern to be applied to each date value (see date patterns)
  15. Select whether to trim leading and trailing whitespace from each individual table column value before insertion
  16. Select whether to run as a batch process (usually faster for very large record sets)
  17. 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
  18. Select the Next button to begin the data import process
  19. 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
  20. Select Finish (or Back to correct errors etc) when the process has completed