Results 1 to 7 of 7
  1. #1
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114

    VBA To Import SharePoint Lists Into Access 2016


    I know the steps for the manual process, but is there a VBA way to import SharePoint list(s) into an access database?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Bing: Access VBA import SharePoint list

    https://anvlpopescu.wordpress.com/20...rosoft-access/

    Docmd.TransferSharePointList
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by June7 View Post
    Bing: Access VBA import SharePoint list

    https://anvlpopescu.wordpress.com/20...rosoft-access/

    Docmd.TransferSharePointList
    In the Dcmd.TransferSharePointList where are these values pulled from?
    Code:
    "{A92FF376-FC2E-4390-BB03-CC47C756EB08}", "{F1AA137A-7C97-4C89-AB79-31447B77545C}"

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I have never used SharePoint and have no idea.

    Did you view the additional link referenced in the one I posted? [removed link that won't work from here, it does work in the above referenced page]
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That link generates a 404 error. Easy enough to get to the right page from the first link you provided where it says the method "is well documented here"
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    That's odd. Never encountered this before.

    Doubly odd because when I copy/paste to another browser window, it works.

    I removed the link from post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by June7 View Post
    I have never used SharePoint and have no idea.

    Did you view the additional link referenced in the one I posted? [removed link that won't work from here, it does work in the above referenced page]
    It states it's the list id and view id of SharePoint. I'll have to google to determine how to get that information, but thanks for the link!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-02-2018, 11:08 AM
  2. Replies: 1
    Last Post: 07-09-2017, 11:14 PM
  3. Access 2016 / Sharepoint App
    By mdm100 in forum SharePoint
    Replies: 0
    Last Post: 02-13-2017, 06:57 AM
  4. Access database with SharePoint lists as backend
    By Gina Maylone in forum SharePoint
    Replies: 8
    Last Post: 11-12-2014, 02:36 AM
  5. Syncronizing Linked Lists from Sharepoint to Access
    By se7en9057 in forum Import/Export Data
    Replies: 0
    Last Post: 11-02-2011, 02:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums