Select the Connection Type OLEDB and the Oledb Driver Type 'Microsoft Excel 2007\2010 Standard Security'.
Press the [...] button next to Data Source 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.