VBA Script for Excel to MySQL Automation

Job ID: 39607314

Budget: £10 – £150 GBP

I am seeking an experienced programmer to develop a Visual Basic for Applications (VBA) script that automates the export of data from Excel to MySQL. The script will handle two critical worksheets: a primary sheet with approximately 900,000 records and a secondary sheet with 17,000 additional rows. The primary task is to extract all records from the primary sheet into corresponding MySQL tables, implementing logic to identify and prevent duplicate entries based on specific identifying columns. It also needs periodic execution capability to seamlessly transfer newer additions from the secondary 17,000 row sheet. Proficiency in VBA, MySQL and handling large datasets is required to efficiently update records without duplication.

You may need to remote into my laptop via TeamViewer or AnyDesk to make any adjustments or configuration to ensure that that the macro fully works.

Key Requirements:
- Develop a VBA script compatible with Excel 2016 or earlier.
- Export data from Excel to MySQL 8.x, ensuring efficient handling of large datasets.
- Implement logic to detect and avoid duplicate entries during data export.
- Enable periodic execution through a macro button in Excel to transfer new additions from the secondary sheet seamlessly.

Ideal Skills and Experience:
- Proficiency in Visual Basic for Applications (VBA) and MySQL.
- Experience with handling and processing large datasets efficiently.
- Strong understanding of Excel and MySQL integration.
- Proven track record of delivering similar automation projects with precision.

Only candidates with demonstrated experience in delivering projects that meet these specific requirements should apply.