SqlBulkCopy Tutorial - Knowledge Base (KB)

Add text when using SQLBulkCopy to SQL Server from excel

I've created a page where our partners can upload excel files with statistics using SQLBulkCopy. The file has multiple sheets and I need to add the name of the sheet into a column in the DB for each row. The names of the sheets will not change so hardcodi...

Importing from Excel to SQL Server c#

I am trying to import data from an Excel file to a table in SQL Server but it is throwing errors.... string ssqltable = "mytable"; string myexceldataquery = "select * from [Order Form$]"; try { string sexcel...

Import Excel file into database using Epplus and Sqlbulkcopy in MVC 5

I am importing a large data file from excel into my database table using Epplus library in MVC5 and Entity Framework 6. It is taking alot of time to copy that file to the database. I am looking to use sqlbulkcopy to insert the data quickly but I am not re...