Can I import or migrate a Microsoft Access 2010 database into SharePoint 2010 Foundation?


I have SharePoint 2010 Foundation configured on my SBS 2011 server. I need to import or migrate legacy access 2010 databases into SharePoint. What are my options here? Obviously my access dbs have frontend forms to allow users to create/update/delete/filter data within the dbs, how can I mimic this functionality in sharepoint and allow further reporting against my access db data from within sharepoint?

Who is Participating?
Jamie McAllister MVPConnect With a Mentor SharePoint ConsultantCommented:
There's no option with Foundation except building out Lists and Forms by hand. If you had Enterprise you'd have Access Services, which would convert Access DBs to Lists and SharePoint Forms. Without that it's a completely manual process.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.