通过窗口形式将Excel数据检索到SQL Server [英] retrive a excel data to sql server through an window form

问题描述

我想通过窗口表单从Excel工作表中检索数据并将其存储在我的sql服务器中.但是它显示了文件输入错误.我们要进行一些过滤，并对数据进行一些计算.因此，我们希望应用程序使用excel工作表数据并将其存储在数据库中，然后从数据库中检索它们.

I want to retrieve data from an excel sheet through an window form and store it in my sql server. But it shows error for file input.We want to make some filter and do some calculation on the data. So we want that the application take excel sheet data and store them on database, we retrieve them from the database.

推荐答案

请首先检查一下此讨论:将MS Excel导入数据表 [

Please have a check on this discussion first: import MS Excel to datatable[^]
if it is not help you to get out of this, please update where and how the error shows, then more help will be available.

这篇关于通过窗口形式将Excel数据检索到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！