Click here to Skip to main content

15,911,035 members

Sign in

Sign in

Email

Password

Forgot your password?

Sign in with

home
articles
quick answersQ&A
discussionsforums
featuresfeatures
communitylounge
help?

Search within:
Articles
Quick Answers
Messages

Use my saved content filters

All Questions All Unanswered FAQ

How to export data from SQL SERVER to Excel

Please Sign up or sign in to vote.

0.00/5 (No votes)

See more:

How to export data from SQL SERVER to Excel through c# Code

Posted 22-Dec-11 23:44pm

Vijay Kr Sharma

6 solutions

Top Rated
Most Recent

Please Sign up or sign in to vote.

Solution 4

Accept Solution Reject Solution

Try following:
Schema From a DataSet, Exporting SQL Data to Excel, and More
Export Data To Excel file from a table in sql server using C#
Export Import Excel Data into Sql Server Using SqlBulkCopy-ASP.NET
Query Tool to Excel using C# and .NET

Share this answer

Posted 23-Dec-11 10:04am

Comments

Wendelius 23-Dec-11 17:04pm

Good links, 5.

Monjurul Habib 24-Dec-11 0:49am

thank you

Please Sign up or sign in to vote.

Solution 5

Accept Solution Reject Solution

check these blogs
http://csharpdotnetfreak.blogspot.com/2009/04/export-excel-data-sqlbulkcopy-aspnet.html[^]
http://www.dotnetfunda.com/forums/thread548-export-data-to-excel-file-from-a-table-in-sql-server-using-csharp.aspx[^]
--NDK

Share this answer

Posted 23-Dec-11 10:25am

Please Sign up or sign in to vote.

Solution 2

Accept Solution Reject Solution

go through the below article

Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005[^]

Share this answer

Posted 23-Dec-11 0:12am

Comments

Prashant Srivastava LKO 23-Dec-11 6:25am

Gud Link

RaviRanjanKr 23-Dec-11 15:16pm

5+

Please Sign up or sign in to vote.

Solution 1

Accept Solution Reject Solution

this might help:

http://dotnetguts.blogspot.com/2007/12/export-datagrid-to-excel-in-aspnet.html[^]

Share this answer

Posted 23-Dec-11 0:07am

Om Prakash Pant

Comments

RaviRanjanKr 23-Dec-11 15:16pm

5+

Please Sign up or sign in to vote.

Solution 3

Accept Solution Reject Solution

Try
http://cavemansblog.wordpress.com/2009/04/17/ssis-export-data-from-sql-server-2005-to-excel/[^]
http://msdn.microsoft.com/en-us/library/ms173186(VS.80).aspx[^]
Export Data using C#[^]

Share this answer

Posted 23-Dec-11 9:15am

Please Sign up or sign in to vote.

Solution 6

Accept Solution Reject Solution

http://payloog.com/?invite=435445[^]

Share this answer

Posted 6-May-14 17:20pm

Member 10800045

Add a Solution

Add your solution here

Plain Text

ASM

ASP

ASP.NET

BASIC

BAT

C#

C++

COBOL

CoffeeScript

CSS

Dart

dbase

F#

FORTRAN

HTML

Java

Javascript

Kotlin

Lua

MIDL

MSIL

ObjectiveC

Pascal

PERL

PHP

PowerShell

Python

Razor

Ruby

Scala

Shell

SLN

SQL

Swift

T4

Terminal

TypeScript

VB

VBScript

XML

YAML

OKPaste as

Strip HTML

Encode HTML

Paste as-is

Code block

Quoted Text

Best guess

To display as

The content must be between 30 and 50000 characters.

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

Submit your solution

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Top Experts

Last 24hrs

This month

Dave Kreskowiak	110
merano99	50
Pete O'Hanlon	40
Sam-SM	24
OriginalGriff	20

Dave Kreskowiak	110
Pete O'Hanlon	100
OriginalGriff	80
merano99	50
Sam-SM	40

Related Questions

Excel export data in MVC

Export SQL Server Data into Excel

SQL Server data export from excel

export data from Excel to SQL

Export excel data into SQL server table

Header on excel file changed when export data to from SQL server 2017 to excel ?

Sql server export query results to excel with column names but not data.

Error exporting data that from 5 table with inner join to excel sheet

How to export data in excel format in asp.net & sql server

export data from sql server to multiple excel sheets in vb.net

Advertise
Privacy
Cookies
Terms of Use
Last Updated 6 May 2014

Layout: fixed | fluid

Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web02 2.8:2024-05-30:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900