I am trying to join an excel table that I have imported into my TOC to a layer that represents huts in a refugee camp; however, the join fails every time.
I have attached the data here if anyone wants to take a hack at it. The nonspatial tabular data file is called A5_Data_GIS_2, and the field I want to join is called housecode. The layer is called houses and the matching field is called House_Num.
Many thanks for any insight into why I can't get this to work.
There is no need to import the table into the TOC. Just rickt click in your shape and click joins. Then pick the option join table to layer and select the required fields and the location of your excel file.
After you joined the tables simply right click on your shapefile and select data - export data. Then you will end up with the new shapefile and table.
If you try to open the attribute table right after joining and prior to exporting you should usually get an SQL error or something like that.
I had a similar problem a few weeks ago until I figured out that exporting the shapefile will do the trick. However, I do not know why.