How to copy data from Sql database to Excel sheet

Question

0.00/5 (No votes)

See more:

hii everybody

please give me Connection String and command and also procedure to copy all the data from sql database to Excel sheet in ASP.NET.

Posted 22-Jul-12 21:58pm

mayank1290

Add a Solution

3 solutions

Solution 1

Google not working where you are?
https://www.google.co.uk/search?sugexp=chrome,mod=3&sourceid=chrome&ie=UTF-8&q=copy+all+the+data+from+sql+database+to+Excel+sheet[^]

Posted 22-Jul-12 22:03pm

OriginalGriff

Solution 2

if you search Google[^] you get 38 million hits

If you restrict your search to CodeProject[^], you get 73 thousand

Apologies if i sound rude, that is not my intention; this question gets asked on here at least twice a week

Please try a modicum of research before you ask a question

Posted 22-Jul-12 22:06pm

barneyman

Add a Solution

Add your solution here

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

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)

Prasad_Kulkarni · Accepted Answer · 2012-07-22T22:06:00

Solution 3

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
How to export data from SQL SERVER to Excel[^]
Fast Exporting from DataSet to Excel[^]

Posted 22-Jul-12 22:06pm

Prasad_Kulkarni

Comments

Espen Harlinn 23-Jul-12 4:09am

Nice set of links :-D

Prasad_Kulkarni 23-Jul-12 4:47am

:) Thank you Espen!

Mohamed Mitwalli 23-Jul-12 4:26am

5+

Prasad_Kulkarni 23-Jul-12 4:47am

Thank you Mohamed!