http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/Demo SQL Server Star Join Query to Excel Pivot Tablehttp://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/en-usThu, 09 Jul 2009 16:44:57 GMTThu, 09 Jul 2009 16:44:57 GMTEvNet (EvNet, Version=1.0.3608.3122, Culture=neutral, PublicKeyToken=null)<p>I find it amazing that I had to write an add-in to do this in one step. &nbsp;In Office 2003, MS Query was the only game in town for getting data from SQL into a PivotTable. Office 2007 arrives and gives us more options, each one taking six or seven more steps to do the same thing. &nbsp;This would be bad enough, except it creates an ugly, less functional PivotTable.</p> <p>I'll put the add-in on codeplex later this week and update this post. &nbsp;If anyone wants to see where the future direction of pivot tables lies, take a look at what tableau software is releasing. &nbsp;Hopefully the PM of the pivot table doesn't use Mike Arcuri's playbook&nbsp;and release an uglier and even less functional pivot table in office 2010.</p> <p>EDIT:&nbsp;<a href="http://sql2excel.codeplex.com/">http://sql2excel.codeplex.com/</a></p> <p>-Josh</p>http://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/?CommentID=476906Sun, 05 Jul 2009 05:10:59 GMThttp://channel9.msdn.com/posts/Joe+Longtin/Demo-SQL-Server-Star-Join-Query-to-Excel-Pivot-Table/?CommentID=4769060http://channel9.msdn.com/476906/WebViewBug.aspx?EVT=0I find it amazing that I had to write an add-in to do this in one step. &nbsp;In Office 2003, MS Query was the only game in town for getting data from SQL into a PivotTable. Office 2007 arrives and gives us more options, each one taking six or seven more steps to do the same thing. &nbsp;This would&#8230;Joshua Ross0http://channel9.msdn.com/476906/Trackback.aspx