Accessing a DSN through MS Excel

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.
  1. Open MS Excel.
  2. Go to Data > From Other Sources > From Data Connection Wizard.
    The Data Connection Wizard opens.
  3. Select ODBC DSN as the type of data source.
  4. Click Next.
  5. From the list of ODBC data sources, select the DSN you wish to connect to.
  6. Click Next.
  7. Ensure the correct model store is selected in the database dropdown.
  8. 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.
  9. 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.