Solved

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

Posted on 2011-03-02
6
602 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:MohitPandit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 9

Expert Comment

by:rawinnlnx9
ID: 35022636
0
 
LVL 36

Expert Comment

by:Miguel Oz
ID: 35023177
0
 
LVL 8

Expert Comment

by:Volox
ID: 35028636
Why not use SSIS and schedule it with a SQL agent job?  Less code, easy to build and easy to maintain.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 5

Author Comment

by:MohitPandit
ID: 35171390
I have done using OLEDB 12.0. I will place code on Monday.
0
 
LVL 5

Accepted Solution

by:
MohitPandit earned 0 total points
ID: 35459088
0
 
LVL 5

Author Closing Comment

by:MohitPandit
ID: 35496402
I have developed myself. I hope that it will be helpful in community.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
array not updating 8 39
ASP.NET data base connection 35 79
.NET Redemption/Outlook Examples 3 23
Using the .NET JSON Serializer to create a single string 6 51
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question