Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Access mdb to Sharepoint

  Date: Oct 08    Category: Sharepoint    Views: 1158

Is it possible for MS Access to export a spreadsheet directly to a sharepoint
2007 portal? Or reverse? We have a database that is not in itself available
online, yet it can connect to the internet. We want to maintain certain data on
the portal and have our database to sync that data. Can we do this?



6 Answers Found

Answer #1    Answered On: Oct 08    

Okay, let me try and rephrase my idea. I want to upload a file to a sharepoint
document list, but I want to do it "unmanned." Can I upload something into a
list this way?

Answer #2    Answered On: Oct 08    

These sound like two (or possibly three) very different objectives. Can you
describe the process and the flow of information?

Answer #3    Answered On: Oct 08    

I found a commandline app called DavCopy which will upload a file to a
document list - which would fulfill part of my proposed process. But to explain
better, we have an offline MS Access database which we use as our main source of
information for contacts. We have a few associates who are outside our house
and do not have access to this database. We don't want to put our network
online either. So, I am thinking that we can at least post the part of the
contact info which they need - as a spreadsheet or excel document, so they could
at least have current information.

The problem is if they want to update that document. There isn't any
no-hands-involved way of getting that back into our main database.

What we would need is a way for access to check for changes to that excel
document and to import the changes if it finds them. Also, access would need to
periodically export a new list when changes are made to our main database. The
effect would be like having a portion of our database online - but not really.
Clear as mud?

Answer #4    Answered On: Oct 08    

Thank you for the extra context :)

Perhaps I'm missing some crucial details, but couldn't you just import the
Access DB into a SharePoint Contact List and then just use that going
forward? You would have all your data in a central location with version
control, security, and disaster recovery (assuming you back up your site
collection or content DB, which should be done anyway).

Answer #5    Answered On: Oct 08    

That seems interesting. From what you say, I can get Sharepoint to read
a accdb file and display it as a list? Well, I can see how to make Access save
a database to the portal, but I don't see how to make a sharepoint list from it.
Can you help me?

Answer #6    Answered On: Oct 08    

If you're using Access 2007, then the following article will show you how to
move the data over. If you like, when the operation is done, you can link
to the new list(s) and edit them from Access as well as from the browser via


It should create one list for each table, so if your DB only has one table,
then the result should be fairly simple.

Didn't find what you were looking for? Find more on Access mdb to Sharepoint Or get search suggestion and latest updates.