1. Pulls down data from selected fields from an existing SQL DB into a table
2. Compares it to an Excel file containing siliar fields using 6 or so IF conditions
3. Deletes duplicates from the Excel file
4. Uploads records to existing DB
44 freelancer chào giá trung bình$150 cho công việc này
Dear client. I checked the requirement carefully. I am so familiar with sql and excel processing with python. I can make a simple python script for your requirement. Please ping me to discuss more. Regards.
Am an sql expert with 8+ years, mysql oracle, mssql but NOT MICROSOFT ACCESS... I would use a different approach that is cleaner and more efficient. Hit me up. Looking forward to working with you.