Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 611
  • Last Modified:

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


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
1 Solution
Miguel OzSoftware EngineerCommented:
Why not use SSIS and schedule it with a SQL agent job?  Less code, easy to build and easy to maintain.
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

MohitPanditAuthor Commented:
I have done using OLEDB 12.0. I will place code on Monday.
MohitPanditAuthor Commented:
I have developed myself. I hope that it will be helpful in community.

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now