Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Connect to Office 365 Sharepoint from Microsoft Access

Posted on 2014-02-17
4
Medium Priority
?
995 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
3 Comments
 
LVL 59

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 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