Share via

Accessing SharePoint data in MSAccess

Anonymous
2022-04-06T10:33:36+00:00

How to get data from SharePoint list to MS Access without logging in to the site from Internet Explore?

Microsoft 365 and Office | SharePoint | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-07T05:27:15+00:00

    Thank You George .

    There is a slight modification in the query, in Access, when trying to create a new Data source to SharePoint list it is throwing error "Microsoft Access could not connect to the site specified. Verify the address of the site"

    But this error disappears if we are logging in the SharePoint site in IE browser

    IE browser is deprecating so we wont be able to connect to Access thereafter

    please let us know how to connect without IE logging of SharePoint

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-04-06T13:03:57+00:00

    Hi Manju,

    Thanks for posting in the community.

    Generally, Access has the built-in feature to connect the SharePoint list (External Data> New Data Source> From Online services> SharePoint list), and you need to sign in the account that has the related permission to the Access application.

    For your reference:

    Import, link, or move data to SharePoint

    If my understanding conflicts with your meaning or you have any updates, please feel free and come back to share with us.

    Regards,

    George

    Was this answer helpful?

    0 comments