This should be easy and quick for connection, insert and update in SQL. Using Excel VBA. Already have a tab with data to export to SQL.
Need to connect to sql to find matching Excel rows in SQL. If key matches, then update. If key not found then insert new record.
13 freelancere byder i gennemsnit $32 på dette job
I readily have multiple these kind of Excel files for my daily day tasks. Relevant Skills and Experience 10+ vb6/vba/mssql experience Proposed Milestones $20 USD - on finish Remote or offline work?