Importing an Existing Table from an OLE DB-compliant Provider Data Source Using the Desktop OLE DB Adapter
To import a table with the desktop OLE DB adapter:
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Desktop OLE DB/ODBC Adapter from the Import Type list box.
3. Select OLE DB Provider under Select Provider Type.
4. Click the Select Provider button in the Logon Information pane.
5. Select a data source from the list provided in the Data Link Properties dialog box. Click the Next button or the Connection tab.
6. Enter a path name to an available file in Item 1 on the Connection tab in the Data Link Properties dialog box, or click the Browse ( ... ) button to locate a database file.
Use the full UNC path if the data source is to be accessed from multiple clients.
7. Enter the user name and password for the data source. (The default user name for Access is Admin. No password is required.)
Clear the Blank Password check box to specify passwords.
Select the Select Allow Saving of Password check box to confirm the password in the CONNX CDD.
8. Click the Test Connection button to verify that the database is available.
9. Click the OK button to return to the Import CDD dialog box.
Normally, only user-defined tables can be selected for import. Select the Include System Tables check box to access system table definitions.
10. Select the Get Statistics check box to identify the table sizes.
This is used for query optimization, using the table sizes as a guide.
11. Click the OK button.
The CONNX Import Table Selection dialog box appears with a list of available tables.
12. Click the Add or Add All button to move the selected tables to the Select Tables for Import pane.
13. Click the OK button to import the selected tables into CONNX.
The imported tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.