Inserting Excel File Records Into SQL Server Database Using ASP. Net CI have often read the common question in forum posts, how to upload Excel file records into a database but no one has provided the proper solution and many solutions contain a lot of code that is not required so by considering the preceding requirements I have decided to write this article to provide the solution to insert Excel file records into the database with a minimum amount of code. So let us start creating an application so beginners can also understand. First create the table named Employee using the following script CREATE TABLE dbo. Employee      id int IDENTITY1,1 NOT NULL,      Name varchar5. NULL,      City varchar5. NULL,      Address varchar5. NULL,      Designation varchar5. NULL,   CONSTRAINT PKEmployee PRIMARY KEY CLUSTERED         id ASC  WITH PADINDEX  OFF, STATISTICSNORECOMPUTE  OFF, IGNOREDUPKEY  OFF, ALLOWROWLOCKS  ON, ALLOWPAGELOCKS  ON ON PRIMARY   ON PRIMARY  Then the design view of the table will look such as follows Create the same Excel file with the following records Now Let us create the sample web application as follows Start All Programs Microsoft Visual Studio 2. File New Web. Site C Empty Web. Site to avoid adding a master page. Provide the web site a name such as Insert. V_S4hEgA/0.jpg' alt='Excel File In Asp Net C#' title='Excel File In Asp Net C#' />Excel. File. Into. Data. Base or another as you wish and specify the location. Then right click on Solution Explorer Add New Item Add Web Form. Drag and drop one Button and File. Uploader controler onto the lt form section of the Default. Now the default. aspx Page source code will look such as follows. Page LanguageC Auto. Event. Wireuptrue Code. FileDefault. aspx. InheritsDefault     lt DOCTYPE html PUBLIC  W3. CDTD XHTML 1. 0 TransitionalEN http www. TRxhtml. 1DTDxhtml. Head. 1 runatserver      lt title Article by Vithal Wadjelt title  lt head  lt body bgcolorblue      lt form idform. White           lt h. Article for CCorner          lt h. Select File                  lt td                  lt td                      lt asp File. Upload IDFile. Upload. Button IDButton. TextUpload On. ClickButton. 1Click                   lt td              lt tr          lt table      lt div      lt form  lt body  lt html  Now open the Default. Excel file as in the following private void Excel. Connstring File. Path                  constr  string. FormatProviderMicrosoft. ACE. OLEDB. 1. 2. Data Source0 Extended PropertiesExcel 1. Xml HDRYES , File. Path          Econ  new Ole. Db. Connectionconstr               Create a function for Sqlconnection as private void connection                sqlconn  Configuration. Manager. Connection. StringsSql. Com. Connection. String          con  new Sql. Connectionsqlconn              Create a function to read and insert an Excel File into the database as private void Insert. Excel. Recordsstring File. Path              Excel. ConnFile. Path           Query  string. FormatSelect Name,City,Address,Designation FROM 0, Sheet. Ole. Db. Command Ecom  new Ole. Db. CommandQuery, Econ         Econ. Open           Data. Set dsnew Data. Set         Ole. Db. Data. Adapter oda  new Ole. Db. Data. AdapterQuery, Econ         Econ. Close         oda. Fillds        Data. Table Exceldt  ds. Tables0        connection                Sql. Bulk. Copy objbulk  new Sql. Bulk. Copycon                objbulk. Destination. Table. Name  Employee                objbulk. Column. Mappings. AddName, Name        objbulk. Column. Mappings. AddCity, City        objbulk. Column. Mappings. AddAddress, Address        objbulk. UploadFile/0c1bb2/insert-bulk-records-into-database-using-Asp-Net-C-Sharp/Images/firstrecord.jpg' alt='Excel File In Asp Net C#' title='Excel File In Asp Net C#' />How to open an Excel file in C The following section explains how to open and read an Excel file through C. For open or read an Excel file in C, first you have to. Here Mudassar Ahmed Khan has explained how to upload Excel File and then read and import its data into DataSet or DataTable using C and VB. Net in ASP. Net Web. In this article I will explain how to import data from Excel files sheet and display in DataGridView control in Windows Forms WinForms application using C and. High performance. NET library to read, write, and convert XLS, XLSX, and CSV files. Works on ASP. NET, ASP. NET MVC, ASP. NET Core,Windows Forms, WPF, UWP, and Xamarin. Column. Mappings. AddDesignation, Designation                con. Open        objbulk. Write. To. ServerExceldt        con. Close       Now call the preceding function on the button click as protected void Button. Clickobject sender, Event. Args e                string Current. How to create and download excel document using asp. The purpose is to use xml, linq or whatever to send an excel document to a customer via a browser. Edit. This article shows how to insert Excel File records Into a SQL Server database using ASP. Net C. This article demostrates with code on how to Export data to an Excel file using Asp. Net. It supports all excel versions since it uses Microsoft. Office. Interop. After a user clicks a button, I want a file to be downloaded. Ive tried the following which seems to work, but not without throwing an exception ThreadAbort which. ASP. NET is a technology for developing, deploying, and running Web applications and it is a part of the Microsoft. NET Framework. File. Path  Path. Get. Full. PathFile. Upload. Posted. File. File. Name          Insert. Excel. RecordsCurrent. File. Path        The entire code of the default. System  using System. Data  using System. IO  using System. Data. Ole. Db  using System. Configuration  using System. Data. Sql. Client    public partial class Default  System. Web. UI. Page        Ole. Db. Connection Econ      Sql. Connection con        string constr,Query,sqlconn      protected void PageLoadobject sender, Event. Args e                        private void Excel. Connstring File. Path                  constr  string. FormatProviderMicrosoft. ACE. OLEDB. 1. 2. Data Source0 Extended PropertiesExcel 1. Xml HDRYES , File. Path          Econ  new Ole. Db. Connectionconstr                   private void connection                sqlconn  Configuration. Manager. Connection. StringsSql. Com. Connection. String          con  new Sql. Connectionsqlconn                        private void Insert. Excel. Recordsstring File. Path                Excel. ConnFile. Path            Query  string. FormatSelect Name,City,Address,Designation FROM 0, Sheet. Ole. Db. Command Ecom  new Ole. Db. CommandQuery, Econ          Econ. Open                Data. Set dsnew Data. Set              Ole. Db. Data. Adapter oda  new Ole. Db. Data. AdapterQuery, Econ              Econ. Close              oda. Fillds              Data. Table Exceldt  ds. Tables0         connection                  Sql. Bulk. Copy objbulk  new Sql. Bulk. Copycon                  objbulk. Destination. Table. Name  Employee                  objbulk. Column. Mappings. AddName, Name         objbulk. Column. Mappings. AddCity, City         objbulk. Column. Mappings. AddAddress, Address         objbulk. Column. Mappings. AddDesignation, Designation                  con. Open         objbulk. Write. To. ServerExceldt         con. Close              protected void Button. Pinnacle Studio 15 Hd Ultimate Collection Ita Adobe on this page. Clickobject sender, Event. Args e                  string Current. File. Path  Path. Get. Full. PathFile. Upload. 1. Posted. File. File. Name          Insert. Excel. RecordsCurrent. File. Path          Now run the application and upload the file as follows Now click on the Upload button and see the records in the database table as Now you have seen how the records are inserted into the database with minimal code and effort. Notes. For detailed code please download the sample Zip file. Do a proper validation such as date input values when implementing. Make the changes in the web. From all the preceding examples you have learned how to insert Excel records into the database. I hope this article is useful for all readers, if you have a suggestion then please contact me.