Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Post
Register
Login
1
Reply
Need a best solution to export data(excel) in SQL on daily b
Mohan Chandra
Jul 7 2016 3:00 AM
206
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
Reading and deleting some words in word document using c#
I want to create dictionary for one to many relation ship