posted 5/16/2010 by MikeMollenhour - Views: [967]
Over the years of being a BI Consultant I have found that there are a lot of power users with excel and Excel is where they feel most comfortable. While Reporting services has made leaps and bounds over previous versions it still takes some extra effort to create a report and export it to excel. Another option to get data back in to excel is to use the query builder here are the steps:
Click the data tab in excel 2007 and select "from other Sources" at the bottom of the dropdown you will find the Microsoft Query button.
After you Select this you will now see the following
Just setup the datasource to go to your server and click OK.
Now you can filter the results as needed and click next
Sort As you like and hit next
Then you can select to return the data to excel or select view data in MS Query to do more advanced things like join tables etc all in a Access type fashion.