Excel to SQL Azure DB
Posted on 2014-11-27
We have an excel workbook that refreshes with data from SQL Server.
We want to set up a SQL Azure DB, repoint the Excel connection to the new SQL Azure DB and refresh excel from Azure. This is all done in a Fixed IP location.
So far no problem....
What if the user of the excel workbook is on a laptop and the laptop is now not in the office it is now on a dynamic Ip address. What is the best way of getting this to work without adding the dynamic IP each time or adding a 0.0.0.0 to 255.255.255.255 range?
Can we host on Azure SharePoint as a go between...any third party apps etc.