Create a File DSN that selects ONLY the tables that your application needs. If you try and load all the tables and fields in Adagio you will blow an ODBC buffer somewhere.

Use the Adagio Data Dictionary Exporter to find the names of the tables you need.

When you create a good DSN, your Excel Test should only offer to link to those tables.