Converting from source to destination of differnt csv files

read your first csv, and write with appropriate format with second csv


        public static DataTable ParseCSV(string path)
        {
            //Unicode Characterset=Unicode
            //UTF-8 Characterset=65001
            //ANSI Characterset=1252
            if (!File.Exists(path))
                return null;
            string full = Path.GetFullPath(path);
            string file = Path.GetFileName(full);
            string dir = Path.GetDirectoryName(full);
            //create the "database" connection string             
            string connString = "Provider=Microsoft.Jet.OLEDB.4.0;"
           + "Data Source=\"" + dir + "\\\";"
           + "Extended Properties=\"Text;Characterset=1252;HDR=Yes;FMT=Delimited('')\"";
            //create the database query            
            string query = "SELECT * FROM " + "[" + file + "]";
            //create a DataTable to hold the query results            
            DataTable dTable = new DataTable();
            //create an OleDbDataAdapter to execute the query            
            OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString);


            try
            {
                //fill the DataTable                
                dAdapter.Fill(dTable);
            }
            catch (InvalidOperationException /*e*/)
            { }
            dAdapter.Dispose();
            string strcellData = "";
            foreach (DataRow dr in dTable.Rows)
            {

                foreach (var fieldValue in dr.ItemArray)
                {
                    object cellData = fieldValue;
                    strcellData += cellData.ToString();
                }
                strcellData += Environment.NewLine;
            }



            System.Windows.Forms.MessageBox.Show(strcellData);
            return dTable;
        }

        public void ExportCSV(string filepathName, string fileOut)
        {
           
            StringBuilder sb = new StringBuilder();
            sb.AppendLine("Name,Mobile,Group");//set your headers here, used comma and delimeter, change to ; if you want semicolon

            DataTable dt = ParseCSV(filepathName);

            foreach (DataRow row in dt.Rows)
            {
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    sb.Append(row[i].ToString() + ","); //used comma and delimeter, change to ; if you want semicolon
                }
                sb.Remove(sb.Length - 1, 1);
                sb.Append(Environment.NewLine);
            }

            File.WriteAllText(fileOut, sb.ToString(), Encoding.Default);


        }