By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 5,322 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

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

P: 14
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..
Apr 11 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Open the excel file using OPENROWSET. Now you have a table and you can do your report.

-- CK
Apr 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.