Groups | Blog | Home
all groups > sql server clients > march 2005 >

sql server clients : Query Analyzer outputs, copy & paste


Alex Müller
3/31/2005 4:05:02 AM
I did not yet find out how to change options so that I can copy & paste query
analyzers output into Excel or Outlook.

In Excel, I need the Columns Headers, they never appear.

In Outlook or word, I'd like a tabular form, not just plain text.

I have checked the Option "print column headers", but this doesn't change
anything :-(

Alex Müller
3/31/2005 5:35:03 AM
No, thats my problem. When I select all (CTRL-A or clicking left upper cell),
and paste it in Excel, I have only the data, not the headers in there.

[quoted text, click to view]

Alex Müller
3/31/2005 5:37:03 AM
Yes, thats right, but for ad-hoc-querys I can write the col headers by hand,
thats often less work than creating a new DTS task :-)

[quoted text, click to view]
Andrew J. Kelly
3/31/2005 8:19:30 AM
In 2000 you can not get column headers with copy and paste. If you use the
grid output in QA and do a Ctrl-A, Ctrl-C and then paste that into Excel you
should get the proper columns in each cell. You can then copy and paste
that into word to get a table format.

--
Andrew J. Kelly SQL MVP


[quoted text, click to view]

Andrew J. Kelly
3/31/2005 10:35:01 AM
You will be able to do that in 2005 but not in 2000.


--
Andrew J. Kelly SQL MVP


[quoted text, click to view]

Marco Pais
3/31/2005 2:25:14 PM
I would recommend using Data Transformation Services... you can export your
query to Excel, Word, txt... whatever...

Regards...

Marco

[quoted text, click to view]

Simon
4/11/2005 3:02:04 AM
Alex, did you ever find a solution to this? I have the same problem

Regards

Simon

[quoted text, click to view]
Gopinath S
4/12/2005 12:00:00 AM
[quoted text, click to view]
Hi Alex

An alternate

1)Select the option result to the file (CTRL+SHIFT+F)
2)Save the file
3)Open the .RPT file in Excel and follow the steps suggested to get the
column header also

HTH

Regards
AddThis Social Bookmark Button