I am trying to import/attach excel data (MaxTemp, MinTemp, precipitation) to a multi-point shapefile. Is there a faster way of doing it other than editing each point shapefile attribute table?
I am trying to import/attach excel data (MaxTemp, MinTemp, precipitation) to a multi-point shapefile. Is there a faster way of doing it other than editing each point shapefile attribute table?
MO
I take it you have a common item between the two tables right?
My personal approach would be to create a database table from the excel data. And, assuming that when you say shapefile you really mean point feature class, you should probably put the the excel data into the same database as your points. Then use a relate to see what data go with what points, via the common item.
I take it you have a common item between the two tables right?
My personal approach would be to create a database table from the excel data. And, assuming that when you say shapefile you really mean point feature class, you should probably put the the excel data into the same database as your points. Then use a relate to see what data go with what points, via the common item.
The problem is that the excel data does not have the same field as the point shapefile. The point names of each point matches the ID field in excel data instead. I would have to add a field that would link them so I can perform a join
Are you going to perform this operation often with data updates from excel that need to be added to the shapefile (or file geodatabase feature class if you go with that format)? If so, I would script this process out.
