I’m presently employed as an Infrastructure Architect for Content and Code, a leading British Microsoft Gold Partner for SharePoint Products and Technologies. I cut my teeth on SharePoint with the release of SharePoint Portal Server 2003, concurrent with my growth from Technical Support Manager to Infrastructure Architect for another British Microsoft Gold Partner. I’m a generalist with specialist understanding of SharePoint, virtualisation, extranets and identity.


30/07/2010 at 5:25 pm
I have been searching for anything on exporting data from lists to access 2007 for the purposes of generating a report. We are currently using sharepoint 2007.
I’m a user, not a developer – but currently with the corrective action system I am conducting UAT on, one thing to really bring this to a complete program would be to be able to export data to a report formatted for distribution not only internally but also to external vendors.
Any guidance here?
Thanks so much
02/08/2010 at 10:26 pm
You should just be able to work with it directly in Access by opening the list. Or you could probably copy and past from the datasheet view (although you may lose version data). Is that sufficient? Or does this Microsoft article help? http://office.microsoft.com/en-us/access-help/introduction-to-integrating-data-between-access-and-a-sharepoint-site-HA010131463.aspx