Import data from Excel to SQL server in ASP.Net

hnmahant

SOLVED CLOSED ACTIVE ANSWERED
User: hnmahant
Posted: on Aug 18, 2018 04:23 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 1675

I have a Excel file.

I want to transfer all data to the SQL server.

I have create a table in the SQL server. I Just want to import excel filie data to the SQL server's particular table. I know its a import facility in the sql server. Through query.

But i want to know how to manage the excel file data as per the sql table.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Aug 19, 2018 11:54 PM
Report

Hi hnmahant,

Refer below article.

Using SqlBulkCopy to import Excel SpreadSheet data into SQL Server in ASP.Net using C# and VB.Net

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Import data from Excel to SQL server in ASP.Net

Company

Explore

Follow us

Contact Us