In Excel 2007, select the Data Connection Wizard as your data source.
Choose the Other/Advanced option.
In the Provider tab, select SAS IOM Data Provider 9.1 (or whatever version).
In the Connection tab and assuming a local SAS installation, you just need to fill in the «SAS Machine DNS Name» as localhost.
In the All tab locate the «SAS Workspace Init Script».
Double click to edit the property value and fill in a SAS libname statement to inform SAS where your data is located.
Press OK again and wait till the following screen appears.
Search for your table.
Save the Data Connection File (if you want) and press Finish.The following windows appears
Select the appropriate and you're done.