0

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint.

Current as a PoC, I put the database on my company One Drive, does it work the same as on Sharepoint?

I am also open to new database solution (instead of MS Access) that works well with Sharepoint today in 2018, Office365 subscription. Thanks!

Improve this question
6
  • Is your question about how to get Access data in to Excel? Or is your question about how the Access database (or Excel?) will behave if it is saved in Sharepoint?
    – Tally
    Commented Sep 27, 2018 at 14:32
  • The database is MS Access which I want to put on Sharepoint. I wish to know how to import data from the database into Excel.
    – Jake
    Commented Sep 27, 2018 at 15:15
  • So you are asking how to import an Access DB into SP so you can export into Excel? What not just export the DB to Excel directly through the Access application?
    – Chris Fells
    Commented Sep 27, 2018 at 23:55
  • @ChrisFells I don't want to import Access DB into SP. I want to put the .accdb file on Sharepoint, then in Excel, import from the .accdb file. .accdb file needs to be on sharepoint so everyone can update the database.
    – Jake
    Commented Sep 28, 2018 at 3:11
  • In that case the question may get flag for being off-topic. It appears its a generic question regarding excel.
    – James Randal
    Commented Sep 28, 2018 at 3:36

1 Answer 1

Reset to default
1

Ok. So there are a couple of solutions depending on whether you have SP Enterprise or not.

Enterprise: Use OneDrive for Business (Really nothing more than a SP Library, but hey... it's branded) just like you would for regular OneDrive.

Enterprise/Non-Enterprise: Load the file to a document library. Make sure you have permissions enabled on the file for everyone who needs to access it. Then point to it just like you would otherwise.

There are specific web parts for both access and excel. I would recommend building a sandbox and making sure the connections work from your SP environment to both before putting this on a production environment.

And honestly, in using the Access webpart, you can allow people to edit directly without even needing to interface Excel so long as you have the webpart and forms setup correctly.

Improve this answer
2
  • Seems there is no Access in the latest Sharepoint, is Access web discontinued?
    – Jake
    Commented Oct 2, 2018 at 10:56
  • Apparently in "Modern" Office suites (365 ProPlus, E3, and E5 and 2019 On Prem) Access is either PC only or completely non-existent (All the other versions not listed.) So while Access is not "dead" it would seem to be better to use something else, like Excel, which does have a web part tie-in instead. My apologies for not realizing, we are still on 2013 On Prem where I work and use SP, which DOES have an Access web part. Considering the functionality of SP with its lists (which are nothing but tables), it might be better to rebuild using SP lists and transferring the data.
    – Chris Fells
    Commented Oct 2, 2018 at 14:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.