Using table headings from Query Analyser in Excel

[tonykblen]

Hi,

Is there a way that the table row names used as headers in the grids tab when a query is run can be cut and pasted into Excel. At the moment all I can do is copy the actual data but not the data headings.

Many thanks,
Tony.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

A good start is half the work.
Every start is difficult .
-Two Gaelic proverbs

 

[JamesLean]

Not directly, no. You can either output the results to a csv file and open that in Excel or output them as text, copy/paste the whole text into Excel and use the "Text to columns" option to split them up.

--James

 

[tonykblen]

Thanks James.

Tony Kennedy BSc. B.I.S.,
MCSA Cand.

A good start is half the work.
Every start is difficult .
-Two Gaelic proverbs