How to import column in Combo Box field

[vaibhav2015]

Hi,

I have one combo Box field in table with multiple selection option for plants.

I want to Import excel file "Plant" column to ComboBox field in table.

In excel file I have create column with data validation list and used VBA codes to multiple selection. When I try to import excel file to access "Import_Table" table all column successfully imported only Combo Box column is not selecting multiple options in access table.

Can you please advice how I can import column in Combobox field in table?

 

[Ranman256]

Not quite sure what you want....
Do you want the excel to import the data to 1 plant's record?
The plant's sub table would get all the records, equivalent to this multi select.
Or
Are you importing all plant records to a lookup table?

Using muli pick combo is a pain since it involves vb coding. There's a way to do it with zero programming using single pick.

 

[sneuberg]

How to do how the combo box set up? What is the row source and how are the column widths set?