?
Solved

Connect to Office 365 Sharepoint from Microsoft Access

Posted on 2014-02-17
4
Medium Priority
?
967 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 2000 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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
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 …
Suggested Courses

765 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