Map Excel columns with database table columns using C# and VB.Net in ASP.Net

Question

How to use EPPLUS for Console application for Porting Excel table to SQL DBI need mapping of Column headers with SQL Table

dharmendr · Accepted Answer

Use SqlBulkCopy classRead your excel data to DataTable or DataSetThen refer below article to map columns nameSqlBulkCopy Bulk Copy data from DataTable DataSet to SQL Server Table using C and VBNet

Map Excel columns with database table columns using C# and VB.Net in ASP.Net

SqlBulkCopy: Bulk Copy data from DataTable (DataSet) to SQL Server Table using C# and VB.Net

Company

Explore

Follow us

Contact Us