SQL Server Query Results To Excel#

There are many times when I just want to run a query and send the results to someone in an excel spreadsheet.

You can easliy copy the and past the results, but you don't get column headers, and you lose formatting in many cases.

Dinakar Nethi has a good article about how to directly import the results of a query into excel.

I just used his method and it worked great.

Categories:  | 
Thursday, April 27, 2006 1:51:33 PM (Central Standard Time, UTC-06:00) #    Comments [3]  | 

 

Thursday, March 29, 2007 9:59:21 AM (Central Standard Time, UTC-06:00)
Please Help!!
Thursday, March 29, 2007 10:08:14 AM (Central Standard Time, UTC-06:00)
With what?
Thursday, March 29, 2007 10:10:37 AM (Central Standard Time, UTC-06:00)
With what?
Name
E-mail
(will show your gravatar icon)
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):

All content © 2008, Christopher May, Inc
Open Job Positions
On this page
Google Ads
This site
Calendar
<November 2008>
SunMonTueWedThuFriSat
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456
Archives
Sitemap
Blogroll OPML
Disclaimer

Powered by: newtelligence dasBlog 1.9.6264.0

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts


Pick a theme: