trouble importing a selection.

I'm having trouble importing a selection. The exception says 4882 Bad ID: The value in the 'LOOKUP_ID' column does not match the expected ID format. I don't know what format it wants?

Tagged:

Comments

  • I always like to copy and paste values into a new excel sheet when creating a file for an import selection to make sure I'm not including any weird formatting from my original file that might cause an error. Sometimes this helps me identify spaces or extra characters that are in the ID field. I also find that I have fewer issues if I exclude all other columns from my import file, so the import selection file is just a single column for ID.