The Import feature allows you to:
- Import data from fixed-length ASCII text files, comma-separated (CSV) ASCII text files, Oracle database tables, or Microsoft Excel files into the application
- Configure import processes
Note: The Tables window also provides an import feature to import data directly into a table. See Import Config Window for more information.
Importing data is a three-step process involving three files as shown in the figure below. The Load Batch and Process Batch processes copy data from one file to the next. The View Batch process identifies which records have error messages (which means that these records were not moved to the target table). 
Note: Importing normally occurs on an on-going basis. The data that you are importing is called a "batch." A source file is a batch. Also, data is grouped by batch in the intermediate Oracle table. Once data is processed into the target Oracle table, it loses its batch designation.
