How to export data from SQL Server to Excel in .net

  • Thread starter Thread starter Neo
  • Start date Start date
N

Neo

Hello All,

I want to do bulk export using ado.net from SQL Server database to MS
Excel document. I would highly appreciate small examle showing how to
do this.

Best Regards,
Neo
 
I am sorry but I don't see import from SQL Server code. I found code
for MS Access to Excel but no where I find code for SQL Server to
Excel.
-Neo
 
¤ I am sorry but I don't see import from SQL Server code. I found code
¤ for MS Access to Excel but no where I find code for SQL Server to
¤ Excel.
¤ -Neo

How about the following:

http://tinyurl.com/htldd


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Use DTS/SSIS or BCP. It can at least export to a delimited list which Excel
can import.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

I am sorry but I don't see import from SQL Server code. I found code
for MS Access to Excel but no where I find code for SQL Server to
Excel.
-Neo
Paul Clement said:
On Wed, 19 Jul 2006 10:07:59 +0200, "Miha Markic [MVP C#]" <miha at
rthand
com> wrote:

¤ This is one way:
¤
http://groups.google.com/group/micr...+group:*dotnet*&rnum=8&hl=sl#17005006c4ff0e12

Thanks Miha. Spared me from having to go dig around through my owns
posts.
;-)
Click to expand...

And I thought you have all memorized in your head :-P
Seriously, you are an authority in this subject :-)
Click to expand...
 
¤ I am sorry but I don't see import from SQL Server code. I found code
¤ for MS Access to Excel but no where I find code for SQL Server to
¤ Excel.
¤ -Neo

Not sure what happened to my post but I'll give it another try:

How about the following:

http://tinyurl.com/htldd


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top