<div>
<a href="https://www.experts-exchange.com/questions/22681581/C-excute-select-query-save-result-in-excel-sheet.html" rel="ugc">https://www.experts-exchange.com/questions/22681581/C-excute-select-query-save-result-in-excel-sheet.html</a><br />

</div>


https://www.experts-exchange.com/questions/22681581/C-excute-select-query-save-result-in-excel-sheet.html [https://www.experts-exchange.com/questions/22681581/C-excute-select-query-save-result-in-excel-sheet.html]


<div>
Check:<br />
<a href="http://www.c-sharpcorner.com/UploadFile/lcamlibel/SqltoExcelDataTransferLC12012005073516AM/SqltoExcelDataTransferLC.aspx" rel="ugc">http://www.c-sharpcorner.com/UploadFile/lcamlibel/SqltoExcelDataTransferLC12012005073516AM/SqltoExcelDataTransferLC.aspx</a><br />
<br />
Do you really need the windows service?<br />
I will use simple query, check:<br />
<a href="http://www.mssqltips.com/tip.asp?tip=1202" rel="ugc">http://www.mssqltips.com/tip.asp?tip=1202</a><br />

</div>


Check:
http://www.c-sharpcorner.com/UploadFile/lcamlibel/SqltoExcelDataTransferLC12012005073516AM/SqltoExcelDataTransferLC.aspx [http://www.c-sharpcorner.com/UploadFile/lcamlibel/SqltoExcelDataTransferLC12012005073516AM/SqltoExcelDataTransferLC.aspx]

Do you really need the windows service?
I will use simple query, check:
http://www.mssqltips.com/tip.asp?tip=1202 [http://www.mssqltips.com/tip.asp?tip=1202]


<div>
Why not use SSIS and schedule it with a SQL agent job? &nbsp;Less code, easy to build and easy to maintain.
</div>


Why not use SSIS and schedule it with a SQL agent job?  Less code, easy to build and easy to maintain.

<div>
I have done using OLEDB 12.0. I will place code on Monday.
</div>


I have done using OLEDB 12.0. I will place code on Monday.

Solution.txt

<div>
I have developed myself. I hope that it will be helpful in community.
</div>


I have developed myself. I hope that it will be helpful in community.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am developing a window service in C#.NET which will extract 7 tables into excel at particular time.<br />
<br />
Note: The volume of data per table would be 60,000 to 80,000 records. Also, I am having [Text], Varchar(Max), bit, money data type in few tables.<br />
<br />
Do anyone have any feedback / suggestion on it?<br />
<br />
Best Regards,<br />
Mohit Sharma
</div>
</div>


Hello,

I am developing a window service in C#.NET which will extract 7 tables into excel at particular time.

Note: The volume of data per table would be 60,000 to 80,000 records. Also, I am having [Text], Varchar(Max), bit, money data type in few tables.

Do anyone have any feedback / suggestion on it?

Best Regards,
Mohit Sharma

C#.NET: Extract Data from SQL Server to Excel

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.