|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Copy Sql Studio Output to Outlook in HTML? Grids to Excel? What giAre there any add-in tools/extensions/fixes available that will let you copy
your sql output to Outlook in an HTML table? I could not believe this was not included in Sql 2005 last year. Also, how about being about the ability to copy "grid" output to excel WITH the column headings? Is that too much to ask for? :) Am I missing something here or are others annoyed by the multi-step process to copy output quickly to other apps? Mike Actually, SQL Server is a data storage and retrieval system, and contrary to
'popular' thought -it is NOT a client display tool. You 'could' use SSIS to output data in many different formats, such as html, or excel. But of course, SSIS is a client tool that can output data formatted in various display forms. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Mike" <M***@discussions.microsoft.com> wrote in message news:EAEE719F-969B-4F56-B330-95BC8B755D60@microsoft.com... > Are there any add-in tools/extensions/fixes available that will let you > copy > your sql output to Outlook in an HTML table? I could not believe this was > not included in Sql 2005 last year. > > Also, how about being about the ability to copy "grid" output to excel > WITH > the column headings? Is that too much to ask for? :) > > Am I missing something here or are others annoyed by the multi-step > process > to copy output quickly to other apps? > > Mike > > Arnie:
Sql Server Management Studio a client tool (referenced in the subject ... the full name would not fit). My original message was a complaint about having to take 2-3 steps to copy output from Sql Studio to other tools like Outlook and Excel. Mike Show quote "Arnie Rowland" wrote: > Actually, SQL Server is a data storage and retrieval system, and contrary to > 'popular' thought -it is NOT a client display tool. > > You 'could' use SSIS to output data in many different formats, such as html, > or excel. But of course, SSIS is a client tool that can output data > formatted in various display forms. > > -- > Arnie Rowland, Ph.D. > Westwood Consulting, Inc > > Most good judgment comes from experience. > Most experience comes from bad judgment. > - Anonymous > > You can't help someone get up a hill without getting a little closer to the > top yourself. > - H. Norman Schwarzkopf > > > "Mike" <M***@discussions.microsoft.com> wrote in message > news:EAEE719F-969B-4F56-B330-95BC8B755D60@microsoft.com... > > Are there any add-in tools/extensions/fixes available that will let you > > copy > > your sql output to Outlook in an HTML table? I could not believe this was > > not included in Sql 2005 last year. > > > > Also, how about being about the ability to copy "grid" output to excel > > WITH > > the column headings? Is that too much to ask for? :) > > > > Am I missing something here or are others annoyed by the multi-step > > process > > to copy output quickly to other apps? > > > > Mike > > > > > > > Yes, you are correct, SSMS is a 'client tool'. But as a client tool, it is
designed to 'manage' SQL Server -hence the name 'Management Studio'. It is not designed as a client input/output tool. It is not a tool designed for the kind of operation you describe. You should investigate using SSIS -note the name includes 'Integration Services' -which leads many of us to conclude that it is designed to 'integrate' with other products and therefore move data into various forms. -- Show quoteArnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't help someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Mike" <M***@discussions.microsoft.com> wrote in message news:63C01C6D-106E-473C-A235-62BACF0614D3@microsoft.com... > Arnie: > > Sql Server Management Studio a client tool (referenced in the subject ... > the full name would not fit). > > My original message was a complaint about having to take 2-3 steps to copy > output from Sql Studio to other tools like Outlook and Excel. > > Mike > > "Arnie Rowland" wrote: > >> Actually, SQL Server is a data storage and retrieval system, and contrary >> to >> 'popular' thought -it is NOT a client display tool. >> >> You 'could' use SSIS to output data in many different formats, such as >> html, >> or excel. But of course, SSIS is a client tool that can output data >> formatted in various display forms. >> >> -- >> Arnie Rowland, Ph.D. >> Westwood Consulting, Inc >> >> Most good judgment comes from experience. >> Most experience comes from bad judgment. >> - Anonymous >> >> You can't help someone get up a hill without getting a little closer to >> the >> top yourself. >> - H. Norman Schwarzkopf >> >> >> "Mike" <M***@discussions.microsoft.com> wrote in message >> news:EAEE719F-969B-4F56-B330-95BC8B755D60@microsoft.com... >> > Are there any add-in tools/extensions/fixes available that will let you >> > copy >> > your sql output to Outlook in an HTML table? I could not believe this >> > was >> > not included in Sql 2005 last year. >> > >> > Also, how about being about the ability to copy "grid" output to excel >> > WITH >> > the column headings? Is that too much to ask for? :) >> > >> > Am I missing something here or are others annoyed by the multi-step >> > process >> > to copy output quickly to other apps? >> > >> > Mike >> > >> > >> >> >> Hey Mike,
There are a couple of ways you can tweak SSMS to be better for your environment > how about being about the ability to copy "grid" output to excel WITH 1) Open SSMS> the column headings? Is that too much to ask for? :) 2) Tools | Options | Query Results | SQL Server | Results to Grid 3) Check "Include column headers when copying or saving the results" > Are there any add-in tools/extensions/fixes available that will let you We don't have a great story around this area, but you can try the > copy > your sql output to Outlook in an HTML table? I could not believe this was > not included in Sql 2005 last year. following... 1) You can copy and paste into Excel and use the text import wizard. Then you'll have the ability to modify the tables however you please. 2) You can use SQL Server 2005 SP2 and make a custom report and then export that to Excel or PDF. Paul A. Mestemaker II Program Manager Microsoft SQL Server Manageability http://blogs.msdn.com/sqlrem/ Show quote "Mike" <M***@discussions.microsoft.com> wrote in message news:EAEE719F-969B-4F56-B330-95BC8B755D60@microsoft.com... > Are there any add-in tools/extensions/fixes available that will let you > copy > your sql output to Outlook in an HTML table? I could not believe this was > not included in Sql 2005 last year. > > Also, how about being about the ability to copy "grid" output to excel > WITH > the column headings? Is that too much to ask for? :) > > Am I missing something here or are others annoyed by the multi-step > process > to copy output quickly to other apps? > > Mike > >  |
|||||||||||||||||||||||
Other interesting topics