import from excel to a multi value look up field

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
 
K

Ken

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top