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?