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?
Adam EhrenworthLead Technology AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

PatHartmanCommented:
I don't use multi-valued fields.  I create my own relationships so that I can control the process.

I'm going to guess that you will need to define the lookup field in RAMP_New to resolve the issue.

To explain what is happening that you cannot see because of the multi-value field - Access is storing the record ID in the table and showing you the value it "looked up".  When you created the new table it didn't have the link to the lookup table so it could only show you the numeric stored value.

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
Jeffrey CoachmanMIS LiasonCommented:
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...?

JeffCoachman
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 Access

From novice to tech pro — start learning today.