Live Updates in Excel and SQL Server
Hello,
Here is my scenario: I have created a table AutzenGIS2200 in a database Autzen2200. I then exported this table with blank data (but with schema) to an Excel spreadsheet and filled in the data.
How do I make it so that the changes in my Excel file update (preferably through automatic processes) the table in SQL Server 2017? If you can, please put this in laymen's terms as I am very new to this and I am being self-taught. That below attachment is a copy of the spreadsheet that needs to be synced.
Thanks!
- Seems like you may find some answers here https://community.powerbi.com/t5/Integrations-with-Files-and/best-way-to-push-data-from-excel-to-sql-server-no-of-rows-keep/td-p/107182 or
