1
vote
2answers
37 views

Changing field type of Excel attribute table for a Join

I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field ...
-1
votes
2answers
40 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
0
votes
0answers
61 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
0
votes
1answer
159 views

arcgis - updating joined excel file when adding a new sheet

When adding a new sheet to a joined Excel file in ArcGIS, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection...? edit: sorry for the delay ...
1
vote
0answers
55 views

How to repair a data source with joins to Excel?

I have a set of MXD files, that do not use relative paths, and related data that have been copied to a new computer. Normally it's not a big problem to repair the data sources in the project, but in ...
1
vote
0answers
54 views

Joining Data in ArcMap Errors

Has anybody encountered issues with ArcMap when joining data? Specifically, my rows join, however, depending on how ArcMap is feeling, I might or might not receive my data in the form of quantities. ...
1
vote
3answers
374 views

Join excel attributes to shape attribute

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by ...
2
votes
1answer
705 views

Joining Excel with arcmap by model builder

I am trying to use the model builder tool in ArcMap 10. I would like to join an Excel file (xls) with a shp.file. The Excel file and the shapefile have one identical column with data but the ...
0
votes
0answers
57 views

Adding a new attribute to shapefile from Excel sheet [duplicate]

I have a shapefile in QGIS and I needed to add a attribute to the attribute table. The problem is that I have the information I need to add in an Excel file. How can I add the information from the ...
4
votes
7answers
18k views

Having problems with joining an excel table to a shapefile in ArcMap

I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...
2
votes
2answers
461 views

Join Issue with Attributes Table

I am trying to Join a Mineral Database (excel) into my Attributes table. Once I do and check the Attributes, it shows up as "NULL". What is causing that, what am I not doing? Can anyone offer ...