sql server programming: Copy Gridresults with the title -- sql server programming

Copy Gridresults with the title

Nic
5/5/2004 11:46:06 PM

sql server programming:

Hi

After executinq a query. The results are in de grid dsiplay with the columnlabels above
Then I copy all the line to paste them in Excel
How can I make that when I copy the results grid (normally I do it by clicking in the left corner of the grid) I also have the cloumnlabes copied in excel

Thank

Re: Copy Gridresults with the title

Bojidar Alexandrov
5/6/2004 11:10:42 AM

It is good idea to look at external datasource feature of Excel - then you
will be able to execute your query from excel (and refresh results with
single click)

For copy/paste - try in QA to get results in text mode (Ctrl+t) and then
copy all the results and paste to Excel - probbaly Excel will understand
what you are copying...

Bojidar Alexandrov

[quoted text, click to view]
clicking in the left corner of the grid) I also have the cloumnlabes copied
in excel.
[quoted text, click to view]