C#- Import/Upload Data from Excel to SQL Server 2008 in Asp.net using C#, VB.Net.

By: Suresh Dasari Dec 18, 2012

Introduction:

Here I will explain how to upload or import data from excel to SQL Server using asp.net in c#, vb.net.

Description:

In previous article I explained Import Excel data to gridview in asp.net, How to Export gridview data to excel/word document, Import Excel data to sql database and some other articles relating to export gridview data. Now I will explain how to upload or import data from excel to SQL Server using asp.net in c#, vb.net.
To implement this concept check below posts here I explained two ways to insert data into database

Read Data from Excel file and insert into SQL Server Database using SQL Bulk

Read data from Excel file and insert into SQL database using XML in asp.net

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS

Subscribe by Email

11 comments :

Anonymous said...: mmm; March 31, 2013 at 12:54 PM
Unknown said...: Hello Sir,

Please give idea for Excel sheet to SQl server insetion using the asp.net C#.; April 20, 2013 at 10:22 PM
Unknown said...: but how to import excel data row by row to database checking blank row; July 26, 2013 at 6:57 AM
Prhemnath Raju said...: Mr. suresh , when i apply this code locally its is executed but when i try to do it over internet it's not working, should i add any reference file to so that i can upload it over internet?; February 4, 2014 at 8:23 PM
Unknown said...: Hello sir,
when i am trying to import data from excel to DB,it shows Violation of primary key Constraint.
how can i add data in to table using exception.
Can you help me to solve this problem.; February 18, 2014 at 9:38 PM
Unknown said...: Dear sir,
Please provide me an idea to save excel data to the sql server 2005.; April 1, 2014 at 8:45 PM
Unknown said...: This comment has been removed by a blog administrator.; October 16, 2014 at 6:33 PM
Anurag Maurya said...: How do i upload csv file which is more than 2 GB.

When i uploaded i got error : Exception of type 'System.OutOfMemoryException' was thrown.; December 19, 2014 at 2:13 AM
Unknown said...: Dear Sir
I am upload Excel file in db using wpf mvvm methods. how i can upload pls help me; August 12, 2015 at 2:52 AM
Anonymous said...: Dear Sir,

I am uploading multiple excel sheets into multiple tables in sql server...How can i write the code using asp.net c#.net.Please help me; October 26, 2015 at 9:58 PM
ds said...: sad; October 28, 2015 at 2:17 AM