Last post Nov 28, 2017 08:40 AM by Cathy Zou
Nov 18, 2017 06:15 AM|Boracay|LINK
Can somebody give me direction or suggestion how can i read a excel file storing in SQL Server table and insert it's data to another table in MVC or Web API ?
any code snippet would be great. Thanks
Nov 18, 2017 09:22 AM|Cathy Zou|LINK
how can i read a excel file storing in SQL Server table
You could Retrieve data from database using Entity Framework or SqlClient
Consume Web API method in ASP.NET MVC:
insert it's data to another table
How to implement bulk insert: https://www.aspsnippets.com/Articles/SqlBulkCopy--Bulk-Insert-records-and-Update-existing-rows-if-record-exists-using-C-and-VBNet.aspx
When you import data from excel to SQL server, at first, you need to create data table according to the excel sheets. Here are some articles about import data from Excel file to Database table in MVC. Please refer to them.
Nov 20, 2017 03:10 AM|Boracay|LINK
my problem is how to read excel file which is currently storing in Database table as BLOB. i need to get the excel file read and save it's data to another sql table using c#
Any help would be appreciated.
Nov 28, 2017 08:40 AM|Cathy Zou|LINK
how to read excel file which is currently storing in Database table as BLOB.
For your problem, i need to know how you store excel file data in database.
'BLOB' means what?
Besides, the links provided in my previous will be helpful for you. you could check first.