title: Insert INTO error when transferring data from DataTable to Access Database
body: <p>I have a datatable with 5 columns, (Song, Artist, Album, Genre, Time) the table allows for me to enter as many rows as i want to create a playlist of music, when the user sees fit they can click the button export the data to access.  My access database has a table named "Playlist" with the same 5 columns as the data table.  When trying to transfer the data, i keep getting the exception error for the Insert INTO statement and I have no idea why because i am using a commandBuilder.  I have attached my class and method thats performing this action.</p>
  
  <p>Please advise!</p>
  
  <pre><code>public void ExportPlaylistToAccess(DataTable playlist)
  
  {
  
   // open connection to the database pathed to
  
   String connection = @"Provider=Microsoft.ACE.OLEDB.12.0;" +
  
   @"Data source= D:\CIS 465\Final Project\VirtualiPod\iTunesPlaylistDatabase.accdb";
  
   using (OleDbConnection con = new OleDbConnection(connection))
  
  {
  
   var adapter = new OleDbDataAdapter();
  
  adapter.SelectCommand = new OleDbCommand("SELECT * from [Playlist]", con);
  
   var cbr = new OleDbCommandBuilder(adapter);
  
  cbr.GetDeleteCommand();
  
  cbr.GetInsertCommand();
  
  cbr.GetUpdateCommand();
  
   try
  
  {
  
  con.Open();
  
  adapter.Update(playlist);
  
  }
  
   catch (OleDbException ex)
  
  {
  
   MessageBox.Show(ex.Message, "Database Error");
  
  }
  
   catch (Exception x)
  
  {
  
   MessageBox.Show(x.Message, "Exception Error");
  
  }
  
  }
  </code></pre>
  
  <p>dataTable creation</p>
  
  <pre><code>private void createPlaylist_Click(object sender, EventArgs e)
  
  {
  
   if (playlist.Rows.Count == 0)
  
  {
  
  playlist.Columns.Add("Song");
  
  playlist.Columns.Add("Artist");
  
  playlist.Columns.Add("Album");
  
  playlist.Columns.Add("Genre");
  
  playlist.Columns.Add("Time");
  
  dataGridView1.DataSource = playlist;
  
  }
  
   else if (playlist.Rows.Count &gt; 0)
  
  {
  
   MessageBox.Show("Please clear your current playlist to create a new one.");
  
  }
  
  }
  
   // adds song to playlist for user upon click
  
   private void addToPlaylist_Click(object sender, EventArgs e)
  
  {
  
   IITTrackCollection tracks = app.LibraryPlaylist.Tracks;
  
   IITTrack currentTrack = app.CurrentTrack;
  
   DataRow newRow;
  
  newRow = playlist.NewRow();
  
  newRow["Song"] = currentTrack.Name;
  
  newRow["Artist"] = currentTrack.Artist;
  
  newRow["Album"] = currentTrack.Album;
  
  newRow["Genre"] = currentTrack.Genre;
  
  newRow["Time"] = currentTrack.Time;
  
  playlist.Rows.Add(newRow);
  
  dataGridView1.DataSource = playlist;
  
  }
  </code></pre>