Export Excel at scheduled time

Question

0.00/5 (No votes)

See more:

Hi can any1 plz suggest me, I'm in need to export data from excel sheet to sql database from a predefined path daily 1PM using c#. how to do it?

Posted 23-Feb-14 18:53pm

DaisyArun

Updated 23-Feb-14 18:58pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CoderPanda · Answer 1 · 2014-02-23T19:04:00

Solution 1

Hi,

These links should help you.

http://technet.microsoft.com/en-us/library/ms140052.aspx[^]

http://stackoverflow.com/a/3474783/2671089[^]

Write back if you are stuck.

[Please accept/up-vote answers or solutions that work for you to encourage participation]

Posted 23-Feb-14 19:04pm

CoderPanda

Comments

DaisyArun 24-Feb-14 1:09am

Hi thanks for your Support, But i Need to schedule a task to do this process? let me know how to do it.

CoderPanda 24-Feb-14 1:11am

Quoting from the same SO discussion...

"...you would have to step through the wizard once manually, to set everything up. Once done, you can save the steps as a SSIS package into SQL Server and have that executed at any given time, by scheduling it in SQL Agent. Works on any machine - 32 or 64 bit - no problem."

DaisyArun 24-Feb-14 1:31am

Is it possible to import data from Excel sheet to SQL database at scheduled time using c#

CoderPanda 24-Feb-14 1:34am

Yes, sure, but in that case you will have to write a windows service that runs at scheduled times and reads excel files from the desired location and imports into sql server. This will be certainly more effort than having a SSIS package.

DaisyArun 24-Feb-14 1:35am

Can you please suggest me how to do that. I'm completely unaware about these concept. Thanks in advance

CoderPanda 24-Feb-14 1:38am

Unfortunately I won't be able to write code for you, but here are steps at a broad level, I am sure if you google you can figure out the way:
1. Write a console app
2. In it, try to read your excel file
3. Identify your DB tables and columns and how they map to the columns in the excel
4. Insert data from your excel into the DB
5. Now if everything works all right, then add a new task scheduler to windows and have this console exe invoked at specified intervals

DaisyArun 24-Feb-14 1:39am

Thank u very much for your support. i'll follow those steps..