Solved

Connect to Office 365 Sharepoint from Microsoft Access

Posted on 2014-02-17
4
954 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 58

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 58
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
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: …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

691 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