I have feature classes of property parcels that are polygons. My client maintains data about the parcels in a google doc spreadsheet (online) and updates the information regularly. I am required to update this information as it relates to the polygons in ArcMap 10.3. Right now I am doing a simple join to an Excel spreadsheet, which I update by copying the online data into. The problem is that I really need to do a one to many since there needs to be more than one record pertaining to each individual polygon.
I can convert the Excel file to a geodatabase table to then do a relate, but then how do I easily update the gdb table? Right now the only way I can see to do this is update the Excel spreadsheet each week, then re-convert the Excel file to a gdb table, overwriting the previous week, and use a relate within the map doc only; given that a gdb relationship class would be voided if I write over the data table.
The other caveat is that I then export the polygons with the joined data to a KML that is used in meeting. I found that the data in a "relate" does not export but the data in a "join" does export to the KML.
Am I understanding all of the ramifications? Could I use some other method of table (i.e. access table) whereby I can copy/paste new data over old data and not lose links? It almost seems that my only option is to make duplicate polygons and add a suffix -1, -2 for the multiple records. (they are linked by the parcel number)