Solved

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

Posted on 2014-02-07
4
467 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
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…

860 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