Understanding Merge Key in Excel import map

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When importing/merging from Excel using a map, as required, I've specified a
Merge Key for each table coming in; tasks, resources, and assignments. Makes
sense so the correct record can be matched and updated. I am trying to find
out more how Project uses this as I am baffled by an error.

I'm importing from a workbook with a tasks, resources, and assignments tab.
A text field is assigned as the merge field for all three. This imports
without error for the Tasks and Resources, even with non-numeric text in the
field. However, for the Assignments table, if that field contains text and
not a number I get an error dialog, "The number you entered is invalid or it
is outside the range for a Number field. Make sure you are typing only
numbers and no letters or other characters in this field, or type a smaller
number." Again, this only occurs for the Assignments table.

Does the Merge Field in the Assignments table have to be a number? What is
it comparing to when merging...the Unique ID? If so, what about the merge
keys for the other two tabs? Non-numeric data there seems fine.

Thanks for your help,

Dale
 
Back
Top