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.
Ciaran FogartyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rainer JeschorCommented:
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
0
Ciaran FogartyAuthor Commented:
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.
0
Rainer JeschorCommented:
Hi,
that depends. Which SQL Server version/edition?
Personally I had always issues when creating Excel files from SSIS (we could mostly solve them but it took quite a time) - especially when running automated jobs and the various x86/x64 dependencies.

What do you mean with offload? Store the entries (rows with column A,D,E,... - so not column B and C)into a SharePoint list?
Then the VBA way might be much easier - and it does not need that much coding knowledge.

SharePoint has Excel Export and Import out-of-the-box but then it is a "all-or-nothing" function and it is one-way only. So using the web query feature, whenever you open the Excel file you get the complete SharePoint content.
http://office.microsoft.com/en-001/sharepoint-foundation-help/synchronize-a-sharepoint-list-with-a-spreadsheet-program-HA101854204.aspx

Does the SharePoint list already exists?
Could you perhaps attach some screenshots about how the Excel file and the list looks like now?
Could you please explain in details what the business process will be (starting point, modifications,...)?

Thanks and HTH
Rainer
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ciaran FogartyAuthor Commented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.