<div>
Hi,<br />
yes this is possible using VBA and the Sharepoint web services.<br />
Could you elaborate in more details about your business process?<br />
Thanks and HTH<br />
Rainer
</div>


Hi,
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

<div>
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.
</div>


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.

<div>
Hi Rainer,<br />
<br />
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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.<br />
<br />
Regards.
</div>
</div>


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.

Write data from a SharePoint 2010 list to Excel Sheet

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.