https://kudutek.com/xlnavigator/'>https://kudutek.com/xlnavigator/
Download the sample excel file from the link below:
https://bit.ly/2kGhg1P
In this second video in my training series on How to Export and Update SQL Server table data using Excel Step by Step, I show you in detail how to update SQL Server table data from Excel. If you missed the first video that shows you what prerequisites you will need and how to get started and export your first data using ADO and VBA in Excel from SQL Server, you can watch it here: • How to Export and Update SQL Server t...
I will update my blog post https://kudutek.com/exportupdatesql... with the sample VBA code that you can paste into your Excel to try it out.
Upcoming videos will continue to refine this solution to include inserts, more update fields with foreign keys consideration, data validation, login prompt popup form, and other cool stuff.
Check out my site https://kudutek.com for more information.