topic Problem Joining a Table to Shape in Data Management Questions

Problem Joining a Table to Shape

JohnHandley — Thu, 26 Jun 2014 14:47:14 GMT

I have a table that was created in Excel and saved as a csv. Add the table to my project, open the table and everything looks fine.

When I try to join the table to a shape file table, I select the field to join in the shape. But when I go to select the field in the csv table, the drop down of field choices is blank.

What am I doing wrong? Thanks

Re: Problem Joining a Table to Shape

JoeBorgione — Thu, 26 Jun 2014 17:00:55 GMT

I have a table that was created in Excel and saved as a csv. Add the table to my project, open the table and everything looks fine.

When I try to join the table to a shape file table, I select the field to join in the shape. But when I go to select the field in the csv table, the drop down of field choices is blank.

What am I doing wrong? Thanks

Hard saying, but you use to of my least liked words: Excel and Shapefile. The problem might be the type of field your spreadsheet/csv file is. Are you really using a Shapefile, or are you using a geodatabase feature class?

My suggestion(s):

Import your Excel worksheet to a geodatabase table. When you do, you can change the field type of any field by using the properties function. If you are really using a shapefile, import it into the same geodatabase.

Re: Problem Joining a Table to Shape

JohnHandley — Thu, 26 Jun 2014 17:23:30 GMT

Hard saying, but you use to of my least liked words: Excel and Shapefile. The problem might be the type of field your spreadsheet/csv file is. Are you really using a Shapefile, or are you using a geodatabase feature class?

My suggestion(s):

Import your Excel worksheet to a geodatabase table. When you do, you can change the field type of any field by using the properties function. If you are really using a shapefile, import it into the same geodatabase.

I am trying to Join this table to a shapefile which has a dbf table.

Re: Problem Joining a Table to Shape

IanMurray — Fri, 27 Jun 2014 12:35:15 GMT

Could you post a screenshot of the table as it shows in ArcMap? It would help to narrow down what the problem might be, since it could be a number of things.

Re: Problem Joining a Table to Shape

DanPatterson_Retired — Fri, 27 Jun 2014 16:18:45 GMT

the source and destination fields must be of the same type....remember spreadsheets columns can contain any type of data so ensure that all data in the column is of the same type