需要一个最佳的解决方案来每天在SQL中导出数据（excel） [英] Need a best solution to export data(excel) in SQL on daily basis
问题描述
我需要你的帮助，请帮助我，第一次发票有两张桌子，第二张是RECEIPT，
我们今天有tally文件，即tallyInvoice_07- 07-2016只有INVOICE，它有50个条目，
和明天的统计我们有两个文件tallyinvoice_08-07-2016它有30个条目，并且tallyreceipt_08-07-2016它有20个条目，
2016年7月9日我还有两个文件
for Invice tallyinvoice_09-07-2016有50个条目和
收据tallyreceipt_09-07-2016有40个条目。
用C＃在我们的服务器上传这个的最佳方式是什么？我需要每天上传。
首先我要在我们的本地计算机上复制一份（本地SQL），然后将其复制到服务器中。
不应该重复价值。
请给我建议
我尝试了什么：
我想在da上尝试导出数据（从excel）到我们的服务器ily基础，
1 invoice_number可能有多个收据栏，意味着发票是30000但客户支付10000和10000和10000，一张发票可能有多个收据。
现在给我解决方案请
尝试写一个.net windows服务并安装到你拥有的系统中理货，如果您知道从计数生成报告的时间，您可以通过在中午或您需要时安排服务来使Windows服务每天运行 - 在Windows服务中您可以处理保存任何项目的方法你需要保存和修改。
看看这些链接，希望这些能帮到你
Office通过C＃中的C＃和vb.net示例将Excel电子表格数据导入到Sql Server表中，VB.NET，Visual Studio 2013的SQL
使用ASP.Net C＃将Excel文件记录插入SQL Server数据库/ A>
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
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.
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#
这篇关于需要一个最佳的解决方案来每天在SQL中导出数据（excel）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
