Transferring Data from SQL Server to Excel using .Net

  • Thread starter Thread starter kumar yogesh via .NET 247
  • Start date Start date
K

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 !!!
 
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]
- (e-mail address removed)

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 !!!
 
Back
Top