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.
Lead-Focused SEO for Staffing Agency Category: Analytics, Content Marketing, Digital Marketing, Internet Marketing, Keyword Research, Lead Generation, Link Building, Search Engine Marketing (SEM), SEO, Social Media Marketing Budget: $30 - $250 USD
Google Ads for App Marketing Category: Advertising, Digital Marketing, Facebook Ads, Facebook Marketing, Google Ads, Instagram Ads, Internet Marketing, Social Media Marketing Budget: $15 - $25 AUD
