Solved

Connect to Office 365 Sharepoint from Microsoft Access

Posted on 2014-02-17
4
916 Views
Last Modified: 2014-03-30
I have office 365 with several tables and I want to create a local access interface with Forms to update / edit those tables.  

here is what  I have done / can do:

if I go to a list in sharepoint  I can open it in access locally and  I can update it etc.... I cannot however figure out how to define a DSN to connect to sharepoint list in access.

Here is what  I want to do:

Create a local form that connects via ODBC to sharepoint list and allows me to update those lists.

How can I connect to my Sharepoint tables / lists from Access?

Thanks.
0
Comment
Question by:halejr1
  • 2
4 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39876738
1. On the external data tab, Import group, click SharePoint List
2. Enter the URL of the SharePoint site
3. Select "Link to data" and click next
4. You should get a listing of the lists in SharePoint.  Select the ones you want and click OK.
5. Check over the linked tables to make sure they linked correctly.

Jim.
0
 
LVL 57
ID: 39876783
uh, just hit me; your using Office 365, you sure the data is in a SharePoint list?   Usually with Office 365, it's in a Azure database.  You access it through SharePoint, which is confusing.

What version of Access are you using with Office 365?  Access 2007/2010 do store their data in SharePoint lists when your doing web databases.

Web Apps in A2013 are a different animal and the data is accessed through Sharepoint, but it's actually sitting in an Azure database behind that.

What have you done to date prior to this?

Jim.
0
 
LVL 8

Author Closing Comment

by:halejr1
ID: 39964811
thank you
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now