Mohan Chandra

Mohan Chandra

  • NA
  • 101
  • 16.8k

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

Jul 7 2016 3:00 AM
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.
 
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 

please give me suggestion

Answers (1)