Crear script sql:

with open('C:/xampp/htdocs/proba/proba.txt', 'w', encoding="utf-8") as t: with open('C:/xampp/htdocs/proba/cart.csv', encoding="utf-8") as f: for linea in f: c = linea.split("") n = len(c) - 1 eh =c[n].split("\n") proba = eh[0].split(";") fecha = (proba[0]).split("/") rfecha = fecha[2] + "-" + fecha[1] + "-" + fecha[0] gasto = (proba[1]) des = (proba[2]) pre = (proba[3]) men = "insert into gastos (Fecha,Gasto,Descripcion,Precio) values ('" + rfecha + "','" + gasto + "'," + '"' + des + '",' + "'" + pre + "');\n" t.write(men) f.close() t.close() Copiar