By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,028 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,028 IT Pros & Developers. It's quick & easy.

Transferring Data from SQL Server to Excel using .Net

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.