import excel data in combobox field

[JPDamme]

Hi,

I have a combo box in my database where i can check muliple items.
(in the form i see the dropdown where i can check multiple values)

Now in excel i hav a list containing multiple items in each cell seperated by "; " between each item in the cell

When i try to import this excel data in my database, it will not import any data.
Any suggestion would be welcome.

Best regards,
Jean-Pierre

[Micron]

Seems like you have a multi value combo there because in a regular combo you can't "check" list items, nor can you select multiple list items. I cannot say if that is the problem but I suspect it is. The list items you see are actually in records (rows) in a hidden table so I would expect the import to fail. I would not use multi value field as a rule so I can't say for sure. Perhaps review
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
About Multi Value Fields - https://www.isladogs.co.uk/multivalu...lds/index.html