
Export data from excel to MySQL
- or -
Post a project like this£65(approx. $87)
- Posted:
- Proposals: 38
- Remote
- #4404088
- Expired
Professional Graphics Designer |2D/3D Logo | Animation |Video editing| Interior/Exterior architecture | Content Writer | Web Content | Translator |

I help businesses turn raw data into revenue using AI, ML, and predictive analytics
Virtual Assistant |Personal Assistant |Administrative Assistant |Administration Support
React.js♥WORDPRESS THEME♥SHOPIFY♥WP theme♥PSD 2 XHTML,HTML5( Bootstrap, Sass, Scss )♥ASP.NET (C#,DNN)♥PHP♥SEO♥SEM

PPH #1 "Top Rated" Service Provider in Development & IT : Wordpress, Shopify, Magento, Squarespace, ZOHO, WHMCS, Salesforce, Vtiger, Learndash, Moodle

11688848120513619287485117943893614344351470994552812275455227239424981627242552537323





Description
Experience Level: Entry
An experienced programmer is sought to build a Visual Basic for Applications script automating data exports from Excel to MySQL. The workbook houses two crucial worksheets - a primary sheet containing nearly nine-hundred-thousand information records, and a secondary with seventeen-thousand supplementary rows. The script must extract all records from the primary sheet into corresponding MySQL tables, incorporating logic to detect duplicate entries based on identifying columns to prevent redundant uploads. It also needs periodic execution capability to seamlessly transfer newer additions from the secondary seventeen-thousand row sheet. Proficiency in VBA, MySQL and handling large datasets is required to efficiently update records without duplication. Only candidates demonstrating proven experience delivering precisely what is outlined here should apply.

James L.
100% (13)Projects Completed
12
Freelancers worked with
8
Projects awarded
65%
Last project
12 Aug 2025
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
HI James,
Please let me know if you have idea for below point to understand me in better way,
What are the specific identifying columns or unique keys that should be used to detect and prevent duplicate records during the export from Excel to MySQL?
Thanks
Naresh -
James
Is your budget a placeholder?
11353841135104
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies