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

[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

 

[Miha Markic [MVP C#]]

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

 

[Paul Clement]

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. ;-)


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Miha Markic [MVP C#]]

¤ 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.
;-)

And I thought you have all memorized in your head
Seriously, you are an authority in this subject

 

[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

 

[Paul Clement]

¤ 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)

 

[William \(Bill\) Vaughn]

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

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.
;-)

And I thought you have all memorized in your head
Seriously, you are an authority in this subject

 

[Paul Clement]

¤ 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)