You can connect to a configured ODBC DSN from a client application, and access the mapped model store to perform the required operations. A DSN is accessible by various client applications, such as MS Excel and MS Access. This example illustrates the steps to connect to an ODBC DSN and access a model store in MS Excel.
-
Open MS Excel.
-
Go to .
The Data Connection Wizard opens.
-
Select ODBC DSN as the type of data source.
-
Click Next.
-
From the list of ODBC data sources, select the DSN you wish to connect
to.
-
Click Next.
-
Ensure the correct model store is selected in the database dropdown.
-
If you wish to select any one of the listed tables of the model store, check the Connect to a specific table check box, and select the desired table.
To select all the listed tables, leave the check box unchecked.
-
Click Next.
The contents of selected tables are imported and displayed on the
spreadsheet.Note: The data displayed in MS Excel is read-only.
However, writes
are possible while accessing a DSN using MS Access and other client
applications.
Note: The example illustrates the process for a 32-bit
ODBC driver.