I have been trying to make a script to automate some steps in a process that uses tables from different databases. One of them changes its name every week - name+date eg: "MegaDataBase_16062019.mdb"
How can I make use of the table in it?
I've tried arcpy.ListWorkspaces, something like:
datain = arcpy.ListWorkspaces("\\hugeserver\mainwork\databases\MegaDataBase_*","Access") tableat = datain+".mdb\WorthyTable"
and that got an error, because the result in "datain" was:
I was linking to
So, the wildcard* works, and I find the MDB I want, but can't make use of it to build the path I need
What I need from that table, is to export it with some fieldmappings to a .GDB on my machine
I used * or ? not quite sure now...tomorrow I can confirm it, and share more info if needed, as well as test your suggestions