I need to create separate tables for each individual time step in a .mdb table. A sample .mdb is attached. I need to be able to first open the .mdb and select the table that I want to use (tblSurface), then create a new table containing all associated data with each different time step (TimeID). So, for tblSurface, as part of the example database below, I need to have a new table created for each TimeID=1, TimeID=2, TimeID=3, TimeID=4, ....TimeID=n. Any help on this would be appreciated!!! I don't really know how to even start this!
I will eventually add the resulting table(s) depending on what time step(s) I need to view to an ArcMap document to convert to a shapefile.