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 :-(
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] "Andrew J. Kelly" wrote: > 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.
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] "Marco Pais" wrote: > I would recommend using Data Transformation Services... you can export your > query to Excel, Word, txt... whatever... > > Regards... > > Marco > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:O0B3HRfNFHA.1040@TK2MSFTNGP12.phx.gbl... > > 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 > > > > > > "Alex Müller" <AlexMller@discussions.microsoft.com> wrote in message > > news:425C7E4F-CBCD-4A33-AAB1-122629BC2D1A@microsoft.com... > >>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 > > > > > >
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] "Alex Müller" <AlexMller@discussions.microsoft.com> wrote in message news:425C7E4F-CBCD-4A33-AAB1-122629BC2D1A@microsoft.com... >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
You will be able to do that in 2005 but not in 2000. -- Andrew J. Kelly SQL MVP [quoted text, click to view] "Alex Müller" <AlexMller@discussions.microsoft.com> wrote in message news:B681101A-8C15-4051-ABE5-51ABC731A4BC@microsoft.com... > 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. > > "Andrew J. Kelly" wrote: > >> 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. > >
I would recommend using Data Transformation Services... you can export your query to Excel, Word, txt... whatever... Regards... Marco [quoted text, click to view] "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:O0B3HRfNFHA.1040@TK2MSFTNGP12.phx.gbl... > 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 > > > "Alex Müller" <AlexMller@discussions.microsoft.com> wrote in message > news:425C7E4F-CBCD-4A33-AAB1-122629BC2D1A@microsoft.com... >>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 > >
Alex, did you ever find a solution to this? I have the same problem Regards Simon [quoted text, click to view] "Alex Müller" wrote: > 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. > > "Andrew J. Kelly" wrote: > > > 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. >
[quoted text, click to view] Alex Müller wrote: > 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
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
Don't see what you're looking for? Try a search.
|