My overall goal:
My coworkers have an excel table which they update/use frequently. The table is not in a format that arcmap can decipher. Therefore, I've created a locked sheet (in the format I need) within the excel table, which points to the data my coworkers use. Periodically throughout the year I need to create a map with features that reflect the changes made in said excel table. My thinking is to store my own table in a geodatabase along with my feature class. I want to be able to easily update my table via a linked excel sheet within said gdb. So ultimately for every new map, I would like to just do a quick query in Access to update my table instead of manually doing it every time.
What I've done so far:
I know arcmap does not recognize the linked table alone, so I must add the linked data to a table, hence this next step: I created a personal geodatabase (.mdb) in arcmap and created a new table within the gdb which includes all the fields I need. When I open my gdb in Access 2013, I add my linked excel sheet. (I want to keep the linked table so it automatically updates when the excel table is updated).
After linking my excel sheet, I want to the append the values of the linked excel sheet to the table I created in my gdb.
I've tried using the Append Query, but nothing happens. The linked excel sheet values do not append to the table I created in my gdb. I also don't see an error messages.
Is there another way to do this? Am I doing something wrong?