Excel Online – Refreshing Data to a SQL Azure Database

Below are the steps to connect to SQL Azure Database and refresh this Data in Excel Online. 1. Open the Excel Rich Client > Data > From Data Connection Wizard > From Data Connection Wizard 2. Choose Other/Advanced 3. Choose SQL Server Native Client 11.0 Note: if you do not have see SQL Server Native…


Excel Online – Refreshing data from an Access Online App (SQL Azure Database).

If you want to refresh the below Access Online data in Excel Online. You will need to carefully create an Excel workbook.  But before you do that, you will need to know your Read-Write Connection Information To view this Open your Access Database > File > Connections > Manage From Any Location Enable Read-Write Connection View Read-Write…