Solved

.Net pull data to an excel file

Posted on 2012-03-15
2
184 Views
Last Modified: 2012-03-16
I'm developing a web application using sql sever 2005 and VS2008. I'd like to pull data from a store procedure to an excel sheet/file, as each row contains a lot of columns. I've searched the internet, and seems each way still has a problem.

Is there anyone can suggest a good way to do it?

Thanks advance.
0
Comment
Question by:minglelinch
2 Comments
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 500 total points
ID: 37725121
0
 
LVL 1

Author Comment

by:minglelinch
ID: 37730034
Nice answer. Is it possible I can change the title font for the excel report generated by the above link? Thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question