Export Import SharePoint list - Need to filter the records extracted from the list

Jan 30, 2013 at 11:46 PM
Edited Jan 31, 2013 at 12:04 AM

Is there a way of specifying the view to filter down the records to export. We have 30000+ records in a list and we mark the older ones as archived which we wish to use as a filter.

Alternatively I have seen references to exporting to a text file as it may be quicker to do this and use a bulk insert process. Any help on whether this would be a better approach would be appreciated.

Also we will migrating the site/list to SharePoint Foundation 2010 in the next couple of months so want to make sure this runs against this version of Sharepoint. Again any help would be appreciated.

Feb 5, 2013 at 8:37 PM
I finally worked out what CAML is and am starting to work out how to use it. The main reference that has helped me so far is:

CAML Tutorial