November 10, 2009 at 8:56 am
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
November 10, 2009 at 11:40 am
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.
November 12, 2009 at 7:45 am
lmu92 (11/10/2009)
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.
I need a select statement result to microsoft office XL file for reporting purpose
November 12, 2009 at 7:59 am
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply