Import Data from Excel to SQL Server without using OLEDB in ASP.Net

Question

How to Upload a excel file without oledb connection using sql server connetion

Shashikant · Accepted Answer

Hiyou can use below article to read excel data into DataSet or DataTablehttpstackoverflowcomquestions3715693importexcelsheetdatatodatagridwithoutusingoledband then insert that DataTable data to Database using below articleSqlBulkCopy Bulk Copy data from DataTable DataSet to SQL Server Table using C and VBNetI hope this will help you out

Import Data from Excel to SQL Server without using OLEDB 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