In order to use Excel for the source of the data input you need to download and install
from the Microsoft Downloads Center the Microsoft Access Database Engine 2010. Then add data source to ODBC Data Sources (32- bit) (in System DSN tab) for the
driver, and select the Microsoft Excel Driver (*.xls *.xlsx *.xlsm *.xlsb).
-
Select Actions > New Group (
) to create a new link group.
-
Select Actions > New Link
.
-
On the Link Definitions dialog, under Import method, select Single table or Module (multiple tables) and select the appropriate target table or module from the list.
You can import data only into a target table that has a table definition (for example,
a table that has a correct definition of a primary key, foreign keys, and reference
tables). If you import data into a target module, all the tables in the target module
must have a table definition. If you select a target table that does not have a table
definition or has an incorrect table definition, an appropriate message will be displayed.
In this case you will have to select another target table or modify the table definition.
To learn more about setting the table definition, see Target Table Definition .
-
Under Source, from the Database type list, select ODBC as the source database platform.
-
From the ODBC profile list, select the appropriate data source file type.
-
Beside File name and path, select Browse.
-
On the Select File dialog, select the source file and then, do one of the following:
-
In the data source file does not have table definitions, select Open to display the file name and path on the Link Definitions dialog.
-
If the file that you selected has table definitions, for example, an Excel spreadsheet, on the Enter Table Name dialog, type the name of the source table in upper case, as it appears in the data source file, and then select OK to display the file name and path on the Link Definitions dialog.
If you are creating a new link based on an existing link, select Save as new link.
-
-
Select Apply and then Close.
-
Select
to display the link you defined in the Link Explorer.