how to send excel data into the sql dbRSS

• • Reply
  zhyanadil.it...

  Member

  17 Points

  88 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

• • Reply
  yogyogi

  Member

  540 Points

  356 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

  Helping you always. Don't forget to click "Mark as Answer" on the post that helped you.
  
• • Reply
  Yuki Tao

  Contributor

  2200 Points

  941 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 "Mark as Answer" if suggestion helps.