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!

​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!  Read More

​