Hi,
I have an .accdb file and 1 of the table has a field that uses multi-select combo box. When i export to excel it looks like "1;2;3;4" in a cell but when i import the worksheet back into Access it returns an error. Is there a way to import those data back into the combox field?
Field data type: Text
Lookup:
Display Control: Combo Box
Row Source Type: Table\Query