Solved

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

Posted on 2011-03-02
6
596 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
6 Comments
 
LVL 9

Expert Comment

by:rawinnlnx9
ID: 35022636
0
 
LVL 35

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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now