title: Unable to migrate data from Ms Access to MySQL workbench using c# "SQL syntax error at Line 1"
body: <p>i have been trying to solve this exception for a few days now but there is no luck in finding it. I am currently trying to transfer data from MS Access to MySQL workbench using C# application</p>
  
  <p>The following error pop out at this line</p>
  
  <pre><code>myCmd.ExecuteNonQuery();
  </code></pre>
  
  <p>with the exception saying that </p>
  
  <blockquote>
    <p>"You have an error in your SQL syntax  , find the right syntax to use
    near <strong>'V REG. 5V,
    0.5A','','Yusuf','',''),('QFN','N230285000','Component','80','Storage' at line 1 "</strong></p>
  </blockquote>
  
  <p>Below is the code where the error occurred. Any advice would be greatly appreciated</p>
  
  <pre><code>private void InsertDatatoTable(DataTable dt_Tbl)
      {
          MySqlConnection mConnection = null;
          try
          {
              string currenttime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");                
              StringBuilder sCommand = new StringBuilder("REPLACE INTO `inventorysystem` (`Product_Name`,`Product_ID`,`Product_Category`,`Quantity`,`Location`,`Manufacturer`,`Project _Name`,`Description`,`MinQuantity`,`Owner`,`QR_Code`,`Color_Type`) VALUES ");
              using (mConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["Data_store"].ToString()))  
              {
                  List&lt;string&gt; Rows = new List&lt;string&gt;();
  
                  for (int i = 0; i &lt; dt_Tbl.Rows.Count; i++)
                  {
                      Rows.Add(string.Format("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", dt_Tbl.Rows[i][0].ToString(), dt_Tbl.Rows[i][1].ToString(), dt_Tbl.Rows[i][2].ToString(), dt_Tbl.Rows[i][3].ToString(), dt_Tbl.Rows[i][4].ToString(), dt_Tbl.Rows[i][5].ToString(),
                          dt_Tbl.Rows[i][6].ToString(), dt_Tbl.Rows[i][7].ToString(), dt_Tbl.Rows[i][8].ToString(), dt_Tbl.Rows[i][9].ToString(), dt_Tbl.Rows[i][10].ToString(), dt_Tbl.Rows[i][11].ToString(), currenttime));
                  }
                  sCommand.Append(string.Join(",", Rows));
                  sCommand.Append(";");
                  mConnection.Open();
                  using (MySqlCommand myCmd = new MySqlCommand(sCommand.ToString(), mConnection))
                  {
                      myCmd.CommandType = CommandType.Text;
                      myCmd.ExecuteNonQuery();
                  }
  </code></pre>