?
Solved

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

Posted on 2014-02-07
4
Medium Priority
?
471 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
[X]
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
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 1500 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

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.

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 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