Forum Discussion

Copper Contributor

Feb 01, 2018

How to update a multi-choice field of a sharepoint list with ADO

Dear Community, I managed to create a VBscript to access a Sharepoint-List, get a recordset, add a line and fields etc. with ADO. One thing that I can't get to work is how to set or update a mu...

Martijn Crabbendam

Copper Contributor

Feb 12, 2019

Hi johnweathington John,

In short, no. Funny is that I went for other solutions in the mean time and am just picking up yesterday to use sharepoint lists again. Main reason is that SharePoint is available to me and a proper (SQL) database is not :-). For now I just avoid multi-choice fields and use text fields in stead and let the script do the logic. I forgot about this post to be honest but will update when I find a solution, will you too?

Kind regards,

Martijn.

bdorman

Copper Contributor

Jun 26, 2025

Hi Martijn,

I'm working on a VBS script that will pull data from a SharePoint list, compare that data with another list extracted from SAP GUI, then update the SharePoint list. I don't have much coding experience, and this is the first time I have used VBS scripting. Can you provide any templates or information that will help me out. I have been able to extract the data from SAP GUI a put that into a .txt file but I have been unable to make a connection or get any data from the SharePoint list.

Thanks