How to GET DATA from Microsoft EXCEL Sheets for Generating REPORTS in SSRS 2005..

[Aswanth]

I'm Using Asp.Net with C# & SSRS 2005 for Generating Reports..

I'm Having HUGE Data in Microsoft Excel Sheets .. I want to Get this Data from this Microsoft Excel Sheets & to Generate REPORTS in SSRS 2005..

Please give me the Suggestions for Doing this..

Thank You..

[ck9663]

Open the excel file using OPENROWSET. Now you have a table and you can do your report.

-- CK