How to provide the oledb or odbc connection for pulling the data from excel file
To pull data from excel, you dont require a connectivity string...
Go to Edit Script-> and click on the table file (button) at the bottom.
that i know bro ... but i want the names of all the sheets inside .xls on runtime .
Pls take a look at this post:
Retrieving data ...