OLE DB Data Import

Prerequisite: The import tables must contain a field for the employee ID and the supervisor ID.

OLE DB: Data link properties

When importing OLE DB DataSource, the Data Link Properties screen is used to choose the database provider, test the connection, set access permissions and spec­ify many other important settings (see below).

To access the Data Link Properties screen:

1. Go to File > Import to launch the Import Wizard.
2. Click Next on the Introduction screen.
3. Choose OLE DB DataSource as the import format.
4. Click Build on the connection parameters page.
5. The Data Link Properties screen will appear.