SQL select statement results to XL file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL select statement results to XL file

SQL select statement results to XL file

Rate Topic

Display Mode

Topic Options

Author

Message

nihal9200_kwada

Posted Tuesday, November 10, 2009 8:56 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:30 PM
Points: 352, Visits: 1,692

I am executing a script to get the required report in prod server. How to get that result into XL file?

Please let me know the process, I am using sql 2005 version

Post #816609

LutzM

Posted Tuesday, November 10, 2009 11:40 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

What do you mean by "XL file"?
Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?
If the former, please search for "XML Workshop" on this site. This will give you a list of articles by J. Sebastian covering a lot of questions regarding usage of XML.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #816709

nihal9200_kwada

Posted Thursday, November 12, 2009 7:45 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:30 PM
Points: 352, Visits: 1,692

lmu92 (11/10/2009)

I need a select statement result to microsoft office XL file for reporting purpose

Post #817836

Erich Brinker

Posted Thursday, November 12, 2009 7:59 AM

SSC Veteran

Group: General Forum Members
Last Login: Saturday, December 10, 2011 6:38 AM
Points: 215, Visits: 633

There are a few ways you can do this.

1. In Excel you can connect to a database and have the query come back to a worksheet.

2. If it is a 1 time thing, you can use the data import/export wizard. Right click on the database you are pulling information from and the Import/Export data option comes up. You select your database as the source, tell it you want to use a query to specify the results, and then tell it to go to excel as the output.

3. If it is a repeating task, setup a report in reporting services. Your users would be able to export into a csv file from the report.

Post #817852

« Prev Topic | Next Topic »

Permissions