Helping you always. Don't forget to click "Mark as Answer" on the post that helped you.
♠ ASP.NET Core Tutorials → Start from the Beginning and become an Expert in 30 days time ♠
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
75 Points
513 Posts
how to send excel data into the sql db
Jan 31, 2019 04:36 AM|zhyanadil.it@gmail.com|LINK
how to send excel data into sql db by ajax
Participant
1253 Points
926 Posts
Re: how to send excel data into the sql db
Jan 31, 2019 12:47 PM|yogyogi|LINK
Kindly refer to this tutorial - How to Import Excel File into Database in ASP.NET MVC
I hope it will help you.
Thanks & Regards
♠ ASP.NET Core Tutorials → Start from the Beginning and become an Expert in 30 days time ♠
Contributor
3710 Points
1431 Posts
Re: how to send excel data into the sql db
Feb 01, 2019 08:25 AM|Yuki Tao|LINK
Hi zhyanadil.it@gmail.com,
Here are some different ways which send excel data into sql db:
1.Using OLEDB library and the read data will be inserted into SQL Server database table using SqlBulkCopy:
https://www.aspsnippets.com/Articles/Import-data-from-Excel-file-to-SQL-Server-in-ASPNet-MVC.aspx
2.Install NuGet package LinqToExce:
https://www.c-sharpcorner.com/article/import-excel-data-to-database-using-Asp-Net-mvc-entity-frame/
3.Install NuGet package EPPlus:
https://www.c-sharpcorner.com/article/import-data-from-excel-to-sql-server-database-using-mvc-code-first-approach/
Best Regards.
Yuki Tao
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.