zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

3 results in tag: import-from-excel

When using SQLBulkCopy to SQL Server from Excel, you may add text.

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...
asp.net import-from-excel sqlbulkcopy
asked by Marcus Lindholm

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...
c# excel import-from-excel sqlbulkcopy sql-server
asked by Umm E Habiba Siddiqui

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...
asp.net-mvc-5 c# entity-framework-6 import-from-excel sqlbulkcopy
asked by Minhal

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!