Forum Discussion
Best way to auto Update SQL Tables based on Source files
Hello, I am wondering if someone could provide some advice/insight for a problem I am facing. I am somewhat new to SQL but have a decent knowledge foundation. The company I work for is not very ...
to auto update based on the changes made in the excel files?
That would mean "event driven", there is no such thing in SQL Server world, so firstly not possible.
You can use the Import/Export wizard or directly a SSIS package to import data on a scheduled base.