I’ll be performing a data migration of customer service / call center data from an overwhelmed custom SharePoint (WSS 3.0) application to CRM Online 2011. All the exports will be via export to Excel. I’ll have to find a way to index all the data, then turn it around and upload it to CRM.
Any tools out there that can make this easier? I’m already planning on using Scribe for the upload. But the export from WSS 3.0, and then the cross-referencing worries me a little.
This turned out to be a job for MS Access 2010. I was able to connect from Access to SharePoint using the External Data “connector / wizard” that connected directly to the SharePoint site and pulled back all of the selected SharePoint custom lists that I needed.