Solved

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

Posted on 2014-02-07
4
462 Views
Last Modified: 2014-02-20
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
Comment
Question by:Jagwarman
4 Comments
 

Author Comment

by:Jagwarman
ID: 39846644
I should add, I am looking to this this with Excel 2010
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39856095
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now