C# Access insert query not working

Okay so this code produces no errors but doesn't add the data to the database. When a button is pressed, it should insert all values in the text boxes into the database.

private void addSportButton_Click(object sender, EventArgs e){

  for(int i = 0; i < numberOfPlayers; i++){

    OleDbConnection connection = new OleDbConnection(CONNECTION STRING HERE);
    OleDbCommand command = new OleDbCommand();

    command.CommandText = "INSERT INTO TotalPlayerName ([PlayerName]) VALUES (@name)";
    command.CommandType = CommandType.Text;
    command.Connection = connection;
    connection.Open();
    command.Parameters.Add("@name", OleDbType.VarWChar).Value = textBox[i].Text;
    command.ExecuteNonQuery();
    connection.Close();
  }
}

What am I doing wrong?

EDIT:

changed some things around in previous sections of code and now there are rows added but nothing appears in the PlayerName field

Code for creating the text boxes

        for (int t = 0; t < 18; t++)
         {

             textBox[t] = new TextBox(); 

             this.Controls.Add(textBox[t]);
             this.textBox[t].Font = new System.Drawing.Font("Calibri", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            // if it is the first text box then it must go in this location
             if (t == 0)
             {

                textBox[t].Location = new Point(32, 41);
                textBox[t].Visible = true;


             }
            else
             {
                 // every other text box will be 27px below the previous
                textBox[t].Location = new System.Drawing.Point(32, 41 + (t * 27));
                textBox[t].Visible = false;


             }
        }