I have flood data from the past ten years written in an Excel table. Now I would like to connect the table to ArcMap, so I can join it with the shapefiles. Normally this isn't that hard, but because we talk about floods, we want to hold the Excel table up to date.
What we want is a connection between ArcMap and Excel/Access so we can edit the tables and the data will automatically change in ArcMap (without a new import->join->etc..).
I think it is something with a geodatabase, but till now it isn't working at all.
Does somebody know if this is possible and how?