'Data Connection between Excel and SQL Server
I have a dataset in Excel which I have imported in SQL Server. Is there a way in which when I make any change in the Excel data set like add/remove/edit rows or columns in Excel, then it gets automatically updated in the SQL Server? How do I establish this dynamic connection for data coming from Excel to SQL Server (in that direction)?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|