Importing columns using the Names method

Use the Columns page of the Import notebook with the Names (method N) radio button selected to import columns from the input file to the target table using column names as the mapping method.

Fields and controls

Authorities and privileges

To import columns using the names method:

1. Open the Import notebook, specify options on the File page, and open the Columns page.
2. Click on the Names radio button in the Include columns by box.
3. Select a column in the Table column box.
4. Click on the Change push button and change the column values.
5. Repeat steps 3 and 4 for every column.
6. 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.
7. 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.
8. Click on OK. The import process begins.

Related information

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