Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tahseenm
Yak Posting Veteran
64 Posts |
 Posted - 2012-10-24 : 11:05:33
|
| I just want to get information how to use my excel sheet to a create a simple SSRS report. What are the steps. Let me know. Thanksmoetahsen |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-24 : 11:43:53
|
| You mean show excel data in a SSRS report? you could add a simple export import task to dump data to a table and then use a queru to fetch from table to show details on report. is this for one time activity or do you've to do this on a daily basis?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tahseenm
Yak Posting Veteran
64 Posts |
Posted - 2012-10-24 : 11:50:39
|
| OK what are the steps to do Import/export from excel in to a table. Are you talking about dump data in to a sql server table. Do I have to create a db also or just table is fine. Also this excel data updates on monthly basis not daily basis. Let me know the steps. Thanks and appreciated.moetahsen |
|
|
|
|
|
|
Use Excel to create SSRS report?