try
            {
                var bd = new BaseDatos();
                var lineasArchivo = File.ReadAllLines(path + archivo);
                progressBar1.Maximum = lineasArchivo.Count();
                var av = 0;
                progressBar1.Value = 0;
                foreach (var line in lineasArchivo)
                {
                    var datosw = new string[100];
                    datosw[1] = line.Substring(1 - 1, 8);
                    datosw[2] = line.Substring(9 - 1, 9);
                    datosw[3] = line.Substring(18 - 1, 40);
                    datosw[4] = line.Substring(58 - 1, 10);
                    datosw[5] = line.Substring(68 - 1, 10);
                    datosw[6] = line.Substring(78 - 1, 6);
                    datosw[7] = line.Substring(84 - 1, 6);
                    datosw[8] = line.Substring(90 - 1, 6);
                    datosw[9] = line.Substring(96 - 1, 2);
                    datosw[10] = line.Substring(98 - 1, 40);
                    datosw[11] = line.Substring(138 - 1, 2);
                    datosw[12] = line.Substring(140 - 1, 40);
                    datosw[13] = line.Substring(180 - 1, 40);
                    datosw[14] = line.Substring(220 - 1, 1);
                    datosw[15] = line.Substring(221 - 1, 1);
                    datosw[16] = line.Substring(222 - 1, 13);
                    datosw[17] = line.Substring(235 - 1, 3);
                    datosw[18] = line.Substring(238 - 1, 8);
                    datosw[19] = line.Substring(246 - 1, 2);
                    datosw[20] = line.Substring(248 - 1, 1);
                    datosw[21] = line.Substring(249 - 1, 4);
                    datosw[22] = line.Substring(253 - 1, 6);
                    datosw[23] = line.Substring(259 - 1, 14);
                    datosw[24] = line.Substring(273 - 1, 5);
                    if (path == GlobalData.PathMmx)
                        datosw[25] = "MEX";
                    else if (path == GlobalData.PathMgdl)
                        datosw[25] = "GDL";
                     var sql = " insert into cat_prod_marzam_AUX values('" + datosw[1] + "'" +
                              ",'" + datosw[2] + "'" +
                              ",'" + datosw[3].Replace("'", "_").Trim() + "'" +
                              "," + datosw[4] + "" +
                              "," + datosw[5] + "" +
                              "," + datosw[6] + "" +
                              "," + datosw[7] + "" +
                              "," + datosw[8] + "" +
                              ",'" + datosw[9] + "'" +
                              ",'" + datosw[10].Trim() + "'" +
                              ",'" + datosw[11] + "'" +
                              ",'" + datosw[12].Trim() + "'" +
                              ",'" + datosw[13].Trim() + "'" +
                              ",'" + datosw[14] + "'" +
                              ",'" + datosw[15].Trim() + "'" +
                              ",'" + datosw[16].Trim().PadLeft(13, '0') + "'" +
                              ",'" + datosw[17] + "'" +
                              ",'" + datosw[18] + "'" +
                              ",'" + datosw[19] + "'" +
                              ",'" + datosw[20] + "'" +
                              ",'" + datosw[21] + "'" +
                              ",'" + datosw[22] + "'" +
                              ",'" + datosw[24] + "'" +
                              ",'" + datosw[25] + "'" +
                              ")";
                    bd.ExecuteCommand(sql);
                    av = av + 1;
                    progressBar1.Value = av;
                }
                dtGrdDownLoaded.Rows.Add(archivo, true);
            }