Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Connect to Office 365 Sharepoint from Microsoft Access

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

596 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