x

Write Sql Query Result To Excel File

I am developing a website where i am using sql server as a back end. The database of my application is too large means the amount of data is very huge. when i am quering to show the report it will take so much time and some time it will timeout. i want that when user click to show the report the sql query result will not show on the front end it will directly write on the excel and user will download it from the browser.

if anyone can help me to do this i will be thankfull.

more ▼

asked Mar 08, 2013 at 12:13 PM in Default

avatar image

puneet.sh09
110 3 4 6

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

There is good article by Robyn Page and Phil Factor:

https://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

more ▼

answered Mar 08, 2013 at 01:35 PM

avatar image

eghetto
2.2k 18 24 31

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x780

asked: Mar 08, 2013 at 12:13 PM

Seen: 981 times

Last Updated: Mar 08, 2013 at 01:35 PM

Copyright 2017 Redgate Software. Privacy Policy