import from excel to a multi value look up field

  • Thread starter Thread starter Sophi
  • Start date Start date
S

Sophi

Hi there
I am learning how to import data from excel. It worked fine except for
where the fields were lookup columns that accepted multiple values. I think
that is the source of the problem.

I don't want to import multiple values, it is just the field it is going
into would accept multiple values if I was entering it manually. The text in
the field I want to import matches one of the items on the multi-value look
up list, but it says it was unparsable.

I tried putting it in quote marks that didn't work.

If you have a simple answer (ie. I can't do VBA yet!) I would very much
appreciate it!! Thanks
Sophie
 
I have the exact same question. I have been experimenting with different
values in the excel spreadsheet, but none of them seem to import correctly.
If anyone could answer this, it would help us both.
 
Back
Top