我想在Visual studio2015中将excel电子表格中的数据导入数据库表
问题描述：
我没有ssis工具，当我按下数据库表时必须出现的任务没有出现。所以我想知道我是否可以尝试一些查询。这将是非常有帮助的。
我尝试过：
i尝试使用所有外部方法，但它没有发生。
i don't have ssis tool and the tasks which has to appear when i press on the database table does not appear . So i wanted to know if i could try with some queries. which would be very helpfull.
What I have tried:
i tried using all external methods but it wasn't happening.
答
使用 EPPlus 库阅读本文： c＃ - Excel使用EPPlus进行DataTable - excel已锁定进行编辑 - 堆栈溢出 [ ^ ]
Read this post in using the EPPlus library : c# - Excel to DataTable using EPPlus - excel locked for editing - Stack Overflow[^]