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.
- In the mapping diagram, select the table and click the
- In the Table properties window, next to Import column headings, click the
- Select the Excel file and open it.
- If the import has finished, click OK and close the properties window.