title: SqlBulkCopy cannot access table
body: <p>After reading in an excel-sheet (to transferTable), I want to add that data to a new table (destinationTable) using SqlBulkCopy, but I'm getting the error:</p>
  
  <pre><code>Cannot access destination table 'test'
  </code></pre>
  
  <p>I've tried using the default tablename and using square brackets, but that didn't work.</p>
  
  <p>Any suggestions?</p>
  
  <pre><code>private void writeToDBButton_Click(object sender, EventArgs e) {
      MakeTable();
      destinationTable.TableName = "test";
      testDBDataSet.Tables.Add("test");
  
      // Connects to the sql-server using Connection.cs
      SqlConnection connection = Connection.GetConnection();
  
      using (connection) {
          connection.Open();
  
          // Uses SqlBulkCopy to copy the data from our transferTable to the destinationTable
          using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection)) {
              bulkCopy.DestinationTableName = destinationTable.TableName;
  
              try {
                  // Write from the source to the destination.
                  bulkCopy.WriteToServer(transferTable);
                  this.dataGridView2.DataSource = destinationTable;
              }
              catch (Exception ex) {
                  MessageBox.Show(ex.Message);
              }
  
              connection.Close();
          }
      }
  }
  
  private void saveDBButton_Click(object sender, EventArgs e) {
      this.Validate();
      this.usersBindingSource.EndEdit();
      this.tableAdapterManager.UpdateAll(this.testDBDataSet);
  }
  
  
  private void MakeTable() {
      for (int counter = 0; counter &lt; columns; counter++) {
          DataColumn dummy = new DataColumn();
          dummy.DataType = System.Type.GetType("System.Double");
          destinationTable.Columns.Add(dummy);
      }
  }
  </code></pre>