How to visualize Access 2013 web app data in Excel

Sriram Varadarajan
 
Solution Architect
March 31, 2017
 
Rate this article
 
Views
1956

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.

Category : Office 365, SharePoint

Author Info

Sriram Varadarajan
 
Solution Architect
 
Rate this article
 
Sriram is a Technology Evangelist with 15+ years experience in Microsoft Technologies. He is an enterprise architect working for large pharmaceutical organization which has presence globally with largest Microsoft implementation ...read more
 

Leave a comment