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.
14 freelancere byder i gennemsnit $32 for dette job
Hi. I can write a quick C# app to do this for you. Contact me to discuss Relevant Skills and Experience 17 years programmer Proposed Milestones $25 USD - delivery
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?