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 tech centered and I was recently asked to put some of our Data into SQL Server. Our source information is in Excel (excel 2013.......). These excel files get updated daily, multiple times a day.
What would be the easiest way to get set the tables in SQL to auto update based on the changes made in the excel files?
I run a fair amount of Power BI and am able to do this by simply hitting the refresh button. Is there an equivalent for SQL?
Thanks in advance!
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.
