Prerequisites to import table data are:

• If the source import file does not match with the destination import table definition, then you must modify the properties of the destination table in the Import Table Data dialog box. Additional columns will be inserted with default value.
• You should know the export properties of the file that you are importing like delimiters, quotes, escape characters and so on. Export properties saved during export operation cannot be changed while importing the file.

Follow the steps below to import table data:

1. Right-click the selected table and select Import Table Data.

   Data Studio displays the Import Table Data dialog box with the following options:

   • Import Data File - This field displays the file path of the imported file. Use the Browse button to select different file.
   • Format - Table data can be imported as CSV, Text or binary format. By default CSV is selected.
   • Include Header - Use this option if the import file has column header. For CSV and Text format, by default this field is selected, although it is not a mandatory field. This field will be disabled for binary format.
   • Quotes - You should enter only single byte character for this field. Quote character should not be same as delimiter and null parameter. For CSV and Text format, by default this field is selected, although it is not a mandatory field. This field will be disabled for binary format.
   • Escape - You should enter only single byte character for this field. If the escape value is same as the quote value, then escape value will be replaced with '\0'. For CSV and Text format, by default this field is selected with value as double quotation mark, although it is not a mandatory field. This field will be disabled for binary format.
   • Replace with Null - You can use this field to replace null value in the table with string. The same null string used while exporting should be used while importing data and this need to be explicitly mentioned. For CSV and Text format, by default this field is selected, although it is not a mandatory field. This field will be disabled for binary format.
   • Encoding - The Encoding field will be pre-populated with the encoding selection made in Preferences > Session Setting tab. This is not a mandatory field.
   • Delimiter - You can select the available delimiter or set customized delimiter in the Other field in the Delimiter section. For CSV and Text format commas(,) will be the default delimiter. This field value should not be same as Quote and Replace Null with field values. For CSV and Text format, by default this field is selected, although it is not a mandatory field. This field will be disabled for binary format. It is mandatory to enter a value when Other field is selected.
   • All Columns - Use this option to quickly select all columns. By default this field is selected. To manually select columns, uncheck this and unselect columns from the Selected Columns list.
     • Available Columns - You can use this column to select specific columns to import.
     • Selected Columns - This field displays the selected columns that will be imported. By default all columns display in this field.

2. Click the Browse button from the Import Data File field.

   The Open dialog box is displayed.

3. In the Open dialog box, select the file to import and click Open.
4. Complete the required fields and click OK.

   The status bar displays the progress of the operation. The imported data is appended to the existing table data.

   The Data Imported Successfully dialog box and status bar displays the status of the completed operation.