Importing Data into Tables

Perform the following steps to import data into a table:

In the Connections panel, right-click Tables under your database connection and choose Import to add data to a new table.

To import data into an existing table, right-click the corresponding table and select Import.

Previewing Data

The Data Preview page enables you to specify preferences that affect the preview display of data to be imported.
Select your data source. Choose Local file to upload from your computer.
Click Browse and select the file you want to import. For example, CSV, Delimited, Text, Excel 95 - 2003 (.xls), or Excel 2003+ (.xlsx)
Modify the following configurations, if required:
- Format: This field is automatically populated based on the file you upload. For example, csv (comma separated value), delimited (delimiter separated value), text (tab separated value), Excel 95 - 2003 (.xls), or Excel 2003+ (.xlsx).
  
  Note: The configuration options shown on the Data Preview page depend on the selected format. For Excel (.xls/.xlsx) imports, only Skip Rows, Preview Row Limit, Worksheet, and Header are displayed. For CSV/Delimited/Text imports, additional options such as Delimiter, Enclosures, Encoding, Line Terminator, and Row Skipping Order are available.
- Delimiter: Select the character that separates columns. For example, , (comma), | (pipe), ; (semicolon), and so on.
- Left Enclosure: Select the character that encloses field values. For example, double quote (“), single quote (‘), opening parenthesis ((), opening brace ({), and opening bracket ([).
- Right Enclosure: Select the character that encloses field values. For example, double quote (“), single quote (‘), closing parenthesis ()), closing brace (}), and closing bracket (]).
- Encoding: Select the character set used for encoding data to be imported. For example, UTF-8, UTF-16, UTF-16LE, and so on.
- Line Terminator: Select the character used for line breaks.
- Row Skipping Order: Select whether to skip rows preceding the import or following a certain point.
- Skip Rows: Enter the number of initial rows to skip before importing.
- Preview Row Limit: Enter the number of rows to preview.
- Worksheet (Excel only): Displayed only when you import an Excel file with multiple sheets and click Preview. It lists all sheets present in the Excel file. You can select the sheet to import. By default, the first sheet is imported.
- Header: Select this checkbox to display headers in the preview.
  
  Note: The Restore State button allows you to restore a previously saved import state, reapplying all saved configurations and settings. This feature helps streamline the import process by making it easy to resume or repeat imports with the same parameters.
Click Preview.

The content of the uploaded file is displayed in the File Content section.
Click Next.

Choosing Import Method

The Import Method page specifies methods for importing data from local files.
In the Import Method list, select Insert.
Enter a table name in the Table Name field if you are importing data into a new table.

For import into an existing table, the table name is auto-populated in this field.
To restrict the number of rows for import, select the Import row limit checkbox and enter the desired value in the accompanying field.
Click Next.

Choosing Columns

The Choose Column page lets you select the specific column from the data set and arrange them in the order you want.
If you want to import specific columns only, select the columns from the Available Columns list and use the arrow button to move them to the Selected Columns list.

To change the order of a selected column in the list for the import operation, select it and use the up and down arrow buttons.
Click Next.

Defining Column Metadata

The Column Definition page enables you to specify information about the columns in the database table for data import. If you are deriving the table definition from an external file, you can modify the attributes of any column in the destination table that will be created during the data import process. When importing data into an existing table, the Column Definition step is different from the process used for a new table. Each source column from the imported file must be mapped to a target column that already exists in the table.
For each of the columns in Source Data Columns, you can modify its attribute as needed.

These include properties such as name, data type, size/precision, scale, default value, comments, and whether the column should allow null values. The available attribute fields for each column may vary depending on the column data type.
Click Next.

Summarizing the Import

The Import Summary page provides a final overview of your import configuration before you execute the import process.
Review all selections and settings to confirm they are correct.

This summary includes details about your destination connection, the table being loaded, file properties, fields selected for import, and import method options.

You can use the Save State button to save your current import setup. This will capture all your configuration settings, Data Preview options, Import Method selections, Column Selection, and Column Definition options.
Click Finish to start the import based on the summary settings.

When importing a file, errors may occur if the data does not match the expected format. For example, if a column defined as NUMBER contains a string value. In such cases, the system will notify you and allow you to choose how to proceed. You will be presented with the following options:
- Continue: Skip the row containing the error and proceed with importing the remaining data.
- Ignore All: Ignore all subsequent errors of this type for the rest of the import operation, skipping any problematic rows automatically.
- Cancel: Abort the import process immediately, and no further data will be imported.
Use Back to return and make changes to previous steps. Click Cancel to abort the import process.