Accessing a DSN through MS Excel - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
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.