Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-03-02
6
Medium Priority
?
607 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 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
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…

618 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