Avatar of Adam Ehrenworth
Adam Ehrenworth
Flag for United States of America asked on

Access VBA - insert for multiselect field from SharePoint into another table

I have a field called RAMP2015Products (it is multiselect and imported from SharePoint and table is named RAMP. I am trying to Insert all records from into a new table called RAMP_New. I have a bunch of other fields I was converting from Memo to TEXT using an Insert SQL code but there is an error for the multi-select field. When I do the insert code as TEXT the multiselect values are deleted and all that is left is a number value that has no meaningful info.

Any suggestions on what type VBA Code is needed to accomplish this?
Microsoft AccessVBA

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon

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.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

There may not be an easy way to do this...
Is it an option to just import the entire table?

I have heard of these Multivalues fields being moved "to" Sharepoint (from Access), ..I have not seen much where these fields are moved from Sharepoint to Access.

Like Pat, I tend not  use these somewhat esoteric fields in my designs.
When this functionality is built into your db already.
In any event, you should be able to go into the source table (wherever the actual values you need to change are stored) to do your modifications.
For example you select multiple classes for one student, ...and you need to modify the classes, ...my guess is that there should be a classes table somewhere that you can modify...?

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes