Daily Excel-to-MySQL Automation
Budget: ₹600 – ₹1,500 INR
I maintain a local Excel workbook that is updated every day. I need a lightweight Python solution that:
• Reads the file from my local drive at 22:00 IST each night.
• Inserts the new rows into my MySQL database while cleanly ignoring duplicates.
• Runs automatically via a simple scheduler (cron on Linux or Windows Task Scheduler—whichever you prefer).
Please keep the code clear, documented, and easy for me to adjust if the column layout changes. A brief README with setup steps and any required libraries is all I need beyond the script itself.
• Reads the file from my local drive at 22:00 IST each night.
• Inserts the new rows into my MySQL database while cleanly ignoring duplicates.
• Runs automatically via a simple scheduler (cron on Linux or Windows Task Scheduler—whichever you prefer).
Please keep the code clear, documented, and easy for me to adjust if the column layout changes. A brief README with setup steps and any required libraries is all I need beyond the script itself.
Related categories:
PHP
Python
Data Processing
Software Architecture
MySQL
Data Integration
Automation
Database Management