MySQL Database Integration for Soccer Data
Budget: £10 – £200 GBP
I need a MySQL table to store soccer results data exported from an Excel file. The data includes Country, League, Home Team, Away Team, Result, etc.
Requirements:
- Export 900,000+ records from a Database sheet
- Daily export of recent records from a primary sheet
- Logic to avoid duplicates based on criteria to be specified
- Status bar to show rows processed
- Message box to confirm completion
- Message box displaying execution time
- Filter sheet to specify which leagues to import
- Sheet for importing data from MySQL
Ideal Skills:
- Proficiency in MySQL and Excel
- Experience in writing scripts to automate data transfer
- Familiarity with handling large datasets
- Attention to detail to ensure data integrity
Requirements:
- Export 900,000+ records from a Database sheet
- Daily export of recent records from a primary sheet
- Logic to avoid duplicates based on criteria to be specified
- Status bar to show rows processed
- Message box to confirm completion
- Message box displaying execution time
- Filter sheet to specify which leagues to import
- Sheet for importing data from MySQL
Ideal Skills:
- Proficiency in MySQL and Excel
- Experience in writing scripts to automate data transfer
- Familiarity with handling large datasets
- Attention to detail to ensure data integrity