Avatar of Ciaran Fogarty
Ciaran FogartyFlag for Ireland asked on

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.
Microsoft SharePoint

Avatar of undefined
Last Comment
Ciaran Fogarty

8/22/2022 - Mon
Rainer Jeschor

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
ASKER
Ciaran Fogarty

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
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Ciaran Fogarty

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy