I recently started working for a land company as their GIS tech. They have no GIS data at all so I am pretty much starting from scratch. I have created shapefiles for all of their land tracts and included the in-house tract number and property type in the attribute table. There is an existing Microsoft Access database with all of the historical data (deeds, sales, purchases) for each tract. What is the best way to link access to my existing shapefiles? I have tried exporting from access into an excel file and then relating in ArcMap, but the field that I am using to relate on (tract number) wont appear. The Excel file has several rows for each tract (each row detalis a different sale). Am I missing something simple? PLEASE HELP!!!
