469,317 Members | 1,870 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Transferring Data from SQL Server to Excel using .Net

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>
Nov 16 '05 #1
1 2012
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>
Nov 16 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Asaf | last post: by
1 post views Thread by R.A.M. | last post: by
2 posts views Thread by garther | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.