Kingston and Chris: many thanks for your responses - absolutely awesome. The level of help offered in these forums is quite extraordinary.

Gayathri: did the responses offered by Kingston and Chris...

Thanks for this thought. I'm just off for a week's holiday so haven't had / got time to think this through, but can I tie a trigger in to my...

Hi Mike

Thanks very much for your suggestion - it works a treat! One less thing to think about over the weekend.

I did wonder if the problem was that the row...

Warning! Brian does point out that this technique may be no good if the file name needs to be known at a later stage in the package becuase the time...

Hi Yakov

I hear what you are saying, but if someone can't get column headers into Excel by following the technique published in the August 2004 edition of SQL Server Magazine (InstantDoc...

I can't believe you posted this

The whole point of the article was to get column headers in.

Hi Lance

-----------------

It could be that I'm really tired (and I am), but step 3 of Method 1 says:

   Click "Results in Text"

So we're no longer in "Grid" mode. The article...

"Now if the article had really told me how to cut and paste the grid results into Excel - with the header row"

But it did...

"It's perfectly natural to export to...

Why do you use such a long-winded way? If you have Results output format as Tab Delimited you can just paste straight into Excel and each column of the query...

"The Best Kept Secret About SQL Query Analyzer"

Er, wasn't this technique published in the August 2004 edition of SQL Server Magazine (InstantDoc ID 43115)?

When I try to access a video I get the following error:

error '80020009'

Exception occurred.

/howto/viewhowto.asp, line 21

Hi Steve

I too use this technique from time to time - it's a neat trick that has all sorts of uses. One slight improvement that takes possibly less effort is...