• I've really enjoyed reading all of these posts and think that the article's title deserves 10/10 for marketing alone!  The amount of information contained in the forum is fantastic.  IMO it doesn't matter that this may have been posted in the past because not everyone has read every article that has been published and this may not be the sort of thing you go searching for, especially if you already have an alternative method.

    I already knew about the Query Analyzer settings to facilitate moving query data to Excel but didn't know about the EM equivalent.  Copying and pasting the query statement into a New View window in EM always gives you the column headers and you don't have to keep changing your Query Analyzer settings so this works best for me.  There's also no footer "rows affected" text using this option, so I haven't found anything wrong with it yet.