How to import the data from excel sheet to sql server database in asp net

This is how Google [^]replies to your query.

Please try some examples yourself. If you face any difficulty while coding, feel free to come back here and ask another question with specific issue describing the scenario.

import-excel-data-to-sql-server-in-Asp-Net/[^]

Import MS Excel data to SQL Server table using C#[^]

CREATE PROC [Ins_Test]
AS
INSERT INTO TABLE_NAME
SELECT * FROM OPENDATASOURCE('MICROSOFT.ACE.OLEDB,12.0'
,'Data Source=c://Q.xlsx;Extended Properties="Excel 12.0"'
)...[Sheet1$]

-------------Call this Proc in .cs page---------------

Refer:
Import Data from Excel to SQL Server[^]
This may help.

Hi UdhayaKumar,

Here is the code

public void ExportToSql(string filename,string savepath)
        {
            
            string connectionString = "";
            savepath = savepath + "\\" + filename;
            if (System.IO.Path.GetExtension(filename) == ".xls")
            {
                connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savepath + ";Extended Properties=Excel 8.0";
            }
            else if (System.IO.Path.GetExtension(filename) == ".xlsx")
            {
                connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +savepath  + "; Extended Properties=Excel 12.0;";
            }

            using (OleDbConnection con = new OleDbConnection(connectionString ))
            {
                
                con.Open();

                OleDbCommand com = new OleDbCommand("Select * from [Sheet1$]", con);

                OleDbDataReader dr = com.ExecuteReader();
                
                using (SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["OnlineExamConnectionString"].ConnectionString))
                {

                    sqlcon.Open();

                    using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlcon))
                    {

                        //bulkCopy.ColumnMappings.Add("[SrNo]", "CollID");
                       
                        //bulkCopy.ColumnMappings.Add("[College Name]", "Name");

                        bulkCopy.DestinationTableName = "tblCollege";

                        bulkCopy.WriteToServer(dr);

                    }

                }

                dr.Close();

                dr.Dispose();
            }


        }

Reference :
[^]

http://www.c-sharpcorner.com/UploadFile/99bb20/import-excel-data-to-sql-server-in-Asp-Net/[^]

If you are fine with the solution ,please rate the solution provided :)

Regards,
Praveen Nelge