Select the Connection type ODBC and the Odbc Driver Type 'Excel'.
Press the [...] button next to Dbq and locate the Excel spreadsheet you wish to access.
Testing and Saving your Connection
Once you have entered your values, you need to press the Test Connection button. This will indicate whether or not DataConnect can connect to your Excel spreadsheet. Common problems are incorrect file name and inaccessable location.
Once you have a succesfully tested your connection, you must press the Save button to store your connection.