https://community.esri.com/t5/arcmap-questions/join-field-tool-isn-t-working-anymore/m-p/1023072#M1965 <P>Use Excel to Table, into a file geodatabase.&nbsp; The excel table presumably has an equivalent join field of the same type as the destination and there are no blank entries?</P> Wed, 03 Feb 2021 17:43:03 GMT DanPatterson 2021-02-03T17:43:03Z https://community.esri.com/t5/arcmap-questions/join-field-tool-isn-t-working-anymore/m-p/1023021#M1964 <P>I use ArcMap 10.6.3 and I've been using the join field tool to add large amounts of data successfully from excel spreadsheets to the attribute tables.</P><P>I would add the spreadsheet to the map and export it as a Dbase table in order to add OIDs so I could use the join field tool.&nbsp;</P><P>I do this by a common field of building number, however recently it says the tool has been successful even though it only adds a small chunk of data, specifically only buildings with numbers 999 and under.&nbsp;</P><P>I have no idea why this is happening so I though I'd throw it out to the community to see if anyone has any theories!</P> Wed, 03 Feb 2021 16:09:53 GMT https://community.esri.com/t5/arcmap-questions/join-field-tool-isn-t-working-anymore/m-p/1023021#M1964 JosephBuonocore 2021-02-03T16:09:53Z https://community.esri.com/t5/arcmap-questions/join-field-tool-isn-t-working-anymore/m-p/1023072#M1965 <P>Use Excel to Table, into a file geodatabase.&nbsp; The excel table presumably has an equivalent join field of the same type as the destination and there are no blank entries?</P> Wed, 03 Feb 2021 17:43:03 GMT https://community.esri.com/t5/arcmap-questions/join-field-tool-isn-t-working-anymore/m-p/1023072#M1965 DanPatterson 2021-02-03T17:43:03Z