How to Store Excel Data into Sql Server..

Create one table in Sql server with What ever excel sheet have field names...


 //Create connection string to Excel work book
        string excelConnectionString =
        @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/Raj Collection For ASP Examples/Raj Practise Examples/Excel InsertData/Test3.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

        //Create Connection to Excel work book
        OleDbConnection excelConnection =
        new OleDbConnection(excelConnectionString);

        //Create OleDbCommand to fetch data from Excel
        OleDbCommand cmd = new OleDbCommand
        ("Select [TitleId],[TitleName] from [Sheet1$]",
        excelConnection);

        excelConnection.Open();
        OleDbDataReader dReader;
        dReader = cmd.ExecuteReader();

        SqlBulkCopy sqlBulk = new SqlBulkCopy(con);
        con.Open();
        sqlBulk.DestinationTableName = "ExcelData";
        sqlBulk.ColumnMappings.Add("TitleId", "TitleId");
        sqlBulk.ColumnMappings.Add("TitleName", "TitleName");
        sqlBulk.WriteToServer(dReader);
        con.Close();