A simple SQL script runner. Contribute to caprica/script-runner development by creating an account on GitHub.

I am by no means a Python Guru, but the code did work for me in converting a 50k line Excel file to MySQL. The script converts data from an Excel file into MySQL-compatible INSERT statements.

Save that batch script with a .bat extension, like GetCSV.bat. Executing that batch script will open up an ftp connection and fire off your commands resulting in filename.csv being downloaded.