How to visualize Access 2013 web app data in Excel


Sriram Varadarajan
Enterprise Architect
Published On :   31 Mar 2017
Visit Count
Today :  1    Total :   168
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

Sharegate: Kick-Ass Tool
Think Your SharePoint & Office 365 Are Secure ? Find Out Now!


Issue Description: The expectation is to consume the Access Web App data inside excel to get some report out of it. But, this may not work for everyone as it needs some network configuration in place to consume this data.

When you try connecting to from Excel, you might end up seeing this error

clip_image002

One of the reason for this might be port 1433 being blocked by firewall.

Resolution:

We could open the Access Web app in the Access client and set “From Any Location” under the connection properties. Once we do that, we could create the connection successfully and get the data.

Additionally, another error may likely be the result of port 1433 being blocked by a firewall rule.

To check this, you can do the following:

1. Open and Administrative command prompt.

2. Type the following:

C:\> ping <myserver>.database.windows.net

3. You would receive 4 “Request timed out” messages.

4. At the end of these messages, you would see that your server name resolved to an IP address.

5. We need this IP address for the next step

6. Now type the following to see if there are any firewalls/routers blocking traffic to port 1433.

C:\>telnet <IP Address> 1433

If Telnet is successful, the window will change to a completely blank screen. If it fails, you will see an error saying it is unable to connect.

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

KWizCom Touch