Skip to end of metadata
Go to start of metadata
Excel connection only

If you are going to use your Excel connection for importing data, you can choose to import the column headings from the Excel file when creating a mapping with a regular table, instead of naming the columns yourself. 

The name of your table must match the name of the Excel worksheet from which you import the column headings, otherwise the column headings will not be imported.

Steps:

  1. In the mapping diagram, select the table and click the  control.

  2. In the Table properties window, next to Import column headings, click the  control.



  3. Select the Excel file and open it.

  4. If the import has finished, click OK and close the properties window.