• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

SharePoint 2010 Export LIsts/add/amend/delete data then Import List back to SharePoint

with SharePoint 2010 is it possible to Export LIsts/add/amend/delete data then Import List back to SharePoint.

This would be done as part of a bigger macro which would compare the data on the downloaded List against external data. Changes would then be made and then I would like to upload the list back to sharepoint with the changes.

Possible or not?

If possible would appreciate step by step as I am not that familiar with Sharepoint

Thanks
0
Jagwarman
Asked:
Jagwarman
1 Solution
 
JagwarmanAuthor Commented:
I should add, I am looking to this this with Excel 2010
0
 
regmigrantCommented:
The MS recommended way is to use Access and the MS Excel link has been 'deprecated' - but they may change their minds again :)

I don't speak from personal experience here but I believe that its possible to use the 2007 add-in with 2010 - you can download it here:-
http://www.microsoft.com/en-us/download/details.aspx?id=9345

However I don't think it provides the sort of 'round trip' you are looking for - its more a way of synchronizing excel table with a sharepoint site.

There is a third party tool here which purports to do the same thing better but I have never used it:-
http://www.codeproject.com/Articles/134054/Restoring-Two-Way-Synchronization-on-SharePoint-Li
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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