Working with Excel Spreadsheets - trillium_discovery - trillium_quality - 17.1

Trillium DQ Installation Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Installation Guide
First publish date
2008
Last updated
2024-10-19
Published on
2024-10-19T09:58:08.471711

If you want to use an Excel spreadsheet as your ODBC data source, you must:

  • Create a Defined Name area for the required data. It is the defined name that appears in the table list when you create an entity.

  • Use a system DSN with the Microsoft Excel driver.

To create a Defined Name area

  1. In Excel, open the spreadsheet that contains the data you want to use.

  2. Select the required data.

  3. From the Insert menu, select Name > Define.

  4. Enter a name for this data source and click OK.