Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 739
  • Last Modified:

linked table xxx is unavailable. microsoft access cannot contact the server. Check your network connectionr

I have been using this process for quite some time but for this particular list I am getting issues.

My Process
What I typically do is:

1.Open a new access “blank” database
2.Click external data then more and select SharePoint list
3.For site address my live data is http://prime.sharepoint.com/teams/gssta/ta/load 
4.Link to data source by creating linked data
5.Then I select the list I am working with BP
6.Next I click excel from import and link and select my excel file which is attached (selecting the tab called testdata) I am appending to table BP
7.Next it tries to process and dies off with the error in the title above
0
Matt Pinkston
Asked:
Matt Pinkston
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
...and have you checked your network connections?

Anything special about this list?

Is this same issue for all users, or just you?
0
 
Matt PinkstonAuthor Commented:
all users same error, net connections are fine
0
 
Jeffrey CoachmanMIS LiasonCommented:
Again, ...
"Anything special about this list?"
...as this seems to be the only variable here...
0
 
Jeffrey CoachmanMIS LiasonCommented:
Remember a user can create an excel file in any way they want
(Row and Columns transposed, Blank Rows or columns, data outside the expected range, Hidden rows/Columns, Subtotals, Pivot tables, Data not starting in Row 1, ...etc)

A "List" need to follow a very specif set of design rules, or it may not be recognized.

Can you post an example of the excel file that generates this error?.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now