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 checkbox, and select the
desired table.
Else, to select all the listed tables, leave the checkbox unchecked.
-
Click Next.
The contents of the selected table(s) 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.