How can I export content from a list over to another list?

Posted on 2011-04-27
Last Modified: 2012-05-11
 Can somebody tell me if there is a way out-of-the-box or programmatically to export the content of a list over to another list?

Thank you

Question by:snazaire
    LVL 9

    Accepted Solution

    there are couple of out of the box solution for this approach

    like using list templates, exporting to spread sheet,using workflows, and sharepoint site content structure UI.

    Check these links

    LVL 5

    Expert Comment

    LVL 7

    Expert Comment

    You can copy data between identical lists but it is awkward. On the source list you use Actions -> Export to Spreadsheet to get the data into Excel. Then you open the second list in Datasheet mode and paste from the spreadsheet. You might have to modify the Datasheet so that the columns are the same.

    You can also do this programmatically using the SharePoint Object Model (server-side) or Web Services (client-side) but this not a trivial exercise. Most organizations use third-party migration tools for this as a result.

    Hope this helps.

    Author Closing Comment

    Great reference this actually solve the exact problem. You hit the nail on the head!!!

    Thank you

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now