Write data from a SharePoint 2010 list to Excel Sheet
Hi,
I am required to investigate if it is possible to write data from an item in a SharePoint 2010 list to an Excel 2010 Sheet e.g. I have an 'assigned to' field in SharePoint and wish to write the data in this field to an Excel sheet and vice versa. Any help is much appreciated.
Regards.
I am required to investigate if it is possible to write data from an item in a SharePoint 2010 list to an Excel 2010 Sheet e.g. I have an 'assigned to' field in SharePoint and wish to write the data in this field to an Excel sheet and vice versa. Any help is much appreciated.
Regards.
Last Comment
ASKER
It sounds like work for the engineering team. I am not a programmer unfortunately. A customer has 104 columns in a spreadsheet and we're looking to offload some columns in a SP list. When the user opens a spreadsheet, data from the SP columns are read in. What is your view on SSIS services for this? Thanks.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Rainer,
It is SQL server 2008. Apologies, I am not clear. I mean synchronisation. I will take a look at the link. The sharepoint list does not exist yet. I do not have more information on business process. Thanks for your help.
It is SQL server 2008. Apologies, I am not clear. I mean synchronisation. I will take a look at the link. The sharepoint list does not exist yet. I do not have more information on business process. Thanks for your help.
Microsoft SharePoint
Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.
40K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
yes this is possible using VBA and the Sharepoint web services.
Could you elaborate in more details about your business process?
Thanks and HTH
Rainer