Transferring Data from SQL Server to Excel using .Net

[kumar yogesh via .NET 247]

Hello,
I want to develop an application to transfer data from sqlserver to excel such that , when we create a workbook in excel ,then we are able to transfer data from SQL Server to excel in away that the first three columns of the table (In SQL Server)move to the First Worksheet of the workbook,the next set ofthree columns moves to the Second Worksheet of the workbook.

Regards & Thanks a million !!!

--------------------------------

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>pglwuzdZvkWNyCOIB2RqCw==</Id>

[Nicholas Paldino [.NET/C# MVP]]

Kumar,

You might want to look into Data Transformation Services. It was
introduced with SQL Server 2000, I believe, and provides an API that you can
use to perform much of the work for you.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"kumar yogesh via .NET 247" <an*******@dotnet247.com> wrote in message
news:ei**************@TK2MSFTNGP09.phx.gbl...
Hello,
I want to develop an application to transfer data from sql server to
excel such that , when we create a workbook in excel , then we are able to
transfer data from SQL Server to excel in a way that the first three columns
of the table (In SQL Server) move to the First Worksheet of the workbook,the
next set of three columns moves to the Second Worksheet of the workbook.

Regards & Thanks a million !!!

--------------------------------

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>pglwuzdZvkWNyCOIB2RqCw==</Id>