public void Exel2Sql1()
    {
        OdbcConnection connection;
        SqlBulkCopy bulkCopy;
        string ConnectionString = @"server=sujitkumar\sqlexpress;database=pubs;uid=sa;pwd=1234;";
        string connstr = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=c:\contact.xls";
        using (connection = new OdbcConnection(connstr))
        {
            OdbcCommand command = new OdbcCommand("Select * FROM [Sheet1$]", connection);

            connection.Open();

            

            // Create DbDataReader to Data Worksheet
            
            using (OdbcDataReader dr = command.ExecuteReader())
            {
                // Bulk Copy to SQL Server

                using (bulkCopy = new SqlBulkCopy(ConnectionString))
                {
                    bulkCopy.DestinationTableName = "Names";
                    bulkCopy.WriteToServer(dr);
                }
                dr.Close();
            }
            
        }

        bulkCopy.Close();
        connection.Close();
    }