Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


How to migrate the reports and Forms of an access database to sharepoint 2010 list?

Posted on 2010-11-19
Medium Priority
Last Modified: 2012-05-10
Hello Everyone,

Could some one help me in figuring out How to migrate the reports,queries and Forms of an access database to sharepoint 2010 list?Any help is greatly appreciated.


Question by:kean86
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 34178920
What version of Access?  I don't know understand what the problem is.  This is already built into Access.  

You just have to
1. select the object,
2. then under External Data, in the Export group, select SharePoint list
3. Specify the url for where the list should go (make sure you have permission)
4. Click OK

Is this not working?

Author Comment

ID: 34180333
Its both Access 2007 and 2010 database.I already have 12 reports and 5 Forms in access database and i need to migrate them to Sharepoint list. Can i have those reports and forms in sharepoint list too. If i just follow these steps
1.select the object,
2. then under External Data, in the Export group, select SharePoint list
3. Specify the url for where the list should go (make sure you have permission)
4. Click OK

Will it do the job of migrating both reports and forms of access database to sharepoint list.If so will reports are available as Views in Sharepoint list?

I think this has explained the problem.

Expert Comment

ID: 34180709
Are you saying that you want to run reports and enter information from Sharepoint?
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.


Author Comment

ID: 34182462
Yes, I would like to use those existing reports in access on share point list too.Is there any way that i can use those existing forms also in Access database in sharepoint?

Accepted Solution

rfportilla earned 2000 total points
ID: 34201277
No, no way that I am aware of.  

SharePoint uses a web front end, but I don't know of any tools that allow you to customize it into being an Access front end.  Although, the inverse is true.  You can export your tables to sharepoint lists and have access use them as linked tables.

If you want to create a web front end, you will have to build it.

However, I think the simplest solution is to make sure that your users have permission to the share where the database is located and just provide a link.  If you give them an Access runtime you don't even need to have a full version of Access.
LVL 17

Expert Comment

ID: 36143833
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question