Excel as Datasource in SSRS report

Question

How can I give Excel as datasource in SSRS report I am developing SSRS report in Visual Studio 2008, please help me in this, I have read various links but unable to get desired results.

Answer 1

In Visual studio - there is an option to create a datasource from an ODBC connection. From these dialogs you should be able to create a machine dsn to the excel file you require.

So...... from your report in visual studio, Click Create new DataSource...