title: Split long strings every 255 characters
body: <p>I want to split the <code>qc</code> column every 255 characters into multiple strings and then concat them back together when I Insert them into Excel. I've tried about everything I can think of, I know this is dumb, but I thought I would ask, but how would I go about doing this? This is my insert code. Thanks!</p>
  
  <pre><code>string lFilename = "myExcel.xls";
  string lDistributorFolder = Server.MapPath(".") + "\\Portals\\0\\Distributors\\" + _currentUser.UserID.ToString() + "\\";
  string lTemplateFolder = System.Configuration.ConfigurationManager.AppSettings["CPCeCommerceTemplates"];
  System.IO.Directory.CreateDirectory(lDistributorFolder);
  
  File.Copy(lTemplateFolder + lFilename, lDistributorFolder + lFilename, true);
  string lConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + lDistributorFolder + "\\" + lFilename + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
  DbProviderFactory lFactory = DbProviderFactories.GetFactory("System.Data.OleDb");
  int lSequence = 0;
  using (DbConnection lConnection = lFactory.CreateConnection())
  {
      lConnection.ConnectionString = lConnectionString;
      lConnection.Open();
  
      foreach (DataRowView rowView in dv)
      {
          DataRow row = rowView.Row;
  
          lSequence++;
  
          using (DbCommand lCommand = lConnection.CreateCommand())
          {
  
              lCommand.CommandText = "INSERT INTO [Sheet1$]";
              lCommand.CommandText += "([First Name],[Last Name],[Title],[Company],[Address],[Address 2],[City],[State],[Zip],[Country],[Work phone],[Email],[Website],[Stamp Time],[Campaign],[Source],[Business Unit],[Market Segment],[Notes],[Other Source Detail],[Description],[Sales Employee firstname],[Sales Employee last name],[Reason],[Status],[Category],[Priority]) ";
              lCommand.CommandText += "VALUES(";
              lCommand.CommandText += "\"" + row["name"].ToString().Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["lastname"].ToString().Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["title"].ToString().Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["company"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["address"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["address2"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["city"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["state"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["zip"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["country"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["workphone"].ToString() + "\",";
              lCommand.CommandText += "\"" + row["email"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["website"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["stamptime"].ToString() + "\",";
              lCommand.CommandText += "\"" + row["campaign"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["source"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + string.Empty + "\",";
              lCommand.CommandText += "\"" + row["market"].ToString() + "\",";
              lCommand.CommandText += "\"" + row["qc"].ToString().Replace("\"", "\"\"").Replace("&amp;nbsp;", " ") + "\",";
              lCommand.CommandText += "\"" + row["othersourcedetail"].ToString() + "\",";
              lCommand.CommandText += "\"" + string.Empty + "\",";
              lCommand.CommandText += "\"" + string.Empty + "\",";
              lCommand.CommandText += "\"" + string.Empty + "\",";
              lCommand.CommandText += "\"" + "Lead" + "\",";
              lCommand.CommandText += "\"" + "Open" + "\",";
              lCommand.CommandText += "\"" + "Lead" + "\",";
              lCommand.CommandText += "\"" + "High" + "\"";
              lCommand.CommandText += ")";
              lCommand.ExecuteNonQuery();
          }
      }
  
      lConnection.Close();
  }
  </code></pre>