Importing columns using the Default column method

Use the Columns page of the Import notebook with the Default (method D) radio button selected to import columns from the input file to the target table using a one-to-one column mapping. If the input file contains more columns than the target table, the additional columns at the end of the input file are dropped.

Fields and controls

Authorities and privileges

To import columns using the default method:

1. Open the Import notebook, specify options on the File page, and open the Columns page.
2. Click on the Default radio button in the Include columns by group box to specify that columns be imported using default settings.

   The Change push button is disabled because you cannot change options when you select Default.

3. If the table contains an identity column, use the Identity column behavior drop-down list to specify how you want data loaded into that column.
4. If the table contains one or more generated columns, use the Generated column behavior drop-down list to specify how you want data to be loaded into those columns.
5. Click on OK. The import process begins.

Related information

• Import -- Overview
• Mapping column positions (method P)
• Mapping data columns by start and end positions (method L)
• Mapping column names (method N)
• Specifying the target table and columns when creating a table