Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • Last Modified:

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

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.

Thanks

kean
0
kean86
Asked:
kean86
  • 3
  • 2
1 Solution
 
rfportillaCommented:
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?
0
 
kean86Author Commented:
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.
0
 
rfportillaCommented:
Are you saying that you want to run reports and enter information from Sharepoint?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
kean86Author Commented:
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?
0
 
rfportillaCommented:
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.
0
 
GreatGermCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now