如何从Excel文件中读取数据并存储到数据库中 [英] how to read data from Excel file and store into database

问题描述

i我的服务器文件夹中有excel文件我想从Excel文件中检索数据并保存到c＃

Hi,

i have excel file in my server folder i want to retrieve data from Excel file and save into database table in c#

推荐答案

参考以下文章：

^ ]

将数据从Excel导入到SQL Server [ ^ ]

http：//www.c -sharpcorner.com/UploadFile/99bb20/import-excel-data-to-sq l-server-in-Asp-Net / [ ^ ]

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql- server-database-using / [ ^ ]



最好的一个： Google [ ^ ]



-KR

Refer the following articles:
Import Data from Excel File to Database Table in ASP.NET MVC 4[^]
Import Data from Excel to SQL Server[^]
http://www.c-sharpcorner.com/UploadFile/99bb20/import-excel-data-to-sql-server-in-Asp-Net/[^]
http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/[^]

And the best one: Google[^]

-KR

请参阅使用MS Excel（xls / xlsx） ）使用MDAC和Oledb [ ^ ]。

请参阅以下链接



http://www.dotnetspider.com/resources/45059-Export-Excel-To- SQL-DataBase.aspx [ ^ ]



将数据从Excel导入SQL Server [ ^ ]

Refer below links

http://www.dotnetspider.com/resources/45059-Export-Excel-To-SQL-DataBase.aspx[^]

Import Data from Excel to SQL Server[^]

这篇关于如何从Excel文件中读取数据并存储到数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！