Need a best solution to export data(excel) in SQL on daily basis

Question

0.00/5 (No votes)

See more:

I need your help,please help me,there are two tables in tally first INVOICE and second is RECEIPT,

we have tally file for today i.e. tallyInvoice_07-07-2016 INVOICE only and it has 50 entry,
and for tomorrow tally we have two files tallyinvoice_08-07-2016 and it has 30 entries, and tallyreceipt_08-07-2016 and it has 20 entries,

on 09 july 2016 i have also two files
for Invice tallyinvoice_09-07-2016 has 50 entries and
for receipt tallyreceipt_09-07-2016 has 40 entries.

what is the best way to upload this in our server in C#.I need upload on daily basis.
first i want to a copy in our local computer(local SQL) and then it copy in server.
there should not be duplicate values.

please give me suggestion

What I have tried:

I want to try export data(from excel) to our server on daily basis,
1 invoice_number may have multiple receipt column, means suppose invoice is 30000 but client pay as 10000 and 10000 and 10000, means for one invoice there may be multiple receipt.

now give me solution please

Posted 6-Jul-16 20:58pm

Member 10192073

Updated 7-Jul-16 18:31pm

Add a Solution

2 solutions

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)

vijeshkumarvijayan · Answer 1 · 2016-07-06T23:38:00

try to write a .net windows Service and install in the system where you are having the tally ,if you know the time when the reports are generated from tally you can make windows service to run on daily basis by Scheduling the service at mid night or at the time you need- in windows service u can handle the methods to save whatever items you need to save and modify.

Daniel Jones · Answer 2 · 2016-07-07T18:31:00

Solution 2

Take a look at these links, hope these will help you
Office Import Excel Spreadsheet data into Sql Server table via C# and vb.net sample in C#, VB.NET, SQL for Visual Studio 2013
Inserting Excel File Records Into SQL Server Database Using ASP.Net C#

Posted 7-Jul-16 18:31pm

Daniel Jones

Comments

Member 10192073 8-Jul-16 3:30am

please give me just solution only for my next question, i am new on technology but my boss ask a question that http://www.codeproject.com/Questions/1111134/How-we-sync-data-into-our-cloud-server-by-using-Cs