Working with Excel Spreadsheets - trillium_discovery - trillium_quality - 17.1

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.