I want to associate an Excel table, to a map in shp format. The table will be modified, so I do not want to convert it to dbf format, nor put it inside the geodatabase. A good exercise for Kill the leisure of this vacation and of step to keep an eye on ArcGIS 9.3 from the Acer Aspire One.
For example I will use the data provided by Xyzmap, taking advantage of advertising for free because they have an excellent tool with which you can connect ArcGIS with Google Maps loading the view as a layer.
- 1. Xyzmap provides a mundi map in shape file format, with a dbf containing two columns: one with the country code and one with the name.
- 2. Also included is an Excel file that has country statistical data, and a column with the country code.
The objective is to associate the Excel table with the map, in an external way so that you can continue to operate with it while you can perform mapping and mapping operations.
The solution in 3 steps
I'm going to use Manifold GIS, and then I'll try it with ArcGIS 9.3
1. Upload map
File> import> drawing
2. Call the table
File> link> table
3. Associate tables
Now for this, I display the table associated with the map, and:
Then a new relation is chosen and the fields to be associated are selected
After this the system allows choosing the columns that are desired to be visible. And now, the tables are associated and you can see in gray those that are from the external table. Make changes in Excel and want to see 3manda updates to right click on the table and select Refresh data.
It should not be more complex, but for now using the tool Add Join, it does not do it to the first step. The message sent by the console is that the Excel table needs an Object ID.
Friends of Xyzmap They recommend passing the xls to dbf, but it is not the intention of the exercise. If someone helps us, we will do good to the community.