I like to convert tables (100+) living in access database to a geodatabase tables, sorting them and deleting unnecessary fields in each table at the same time. I figured I use the Sort_management method to convert and sort the tables followed by DeleteField_management method to delete the fields. Here is the code that I have written,
import arcpy from arcpy import env env.workspace = "E:\Database Project\ACS Estimate 2011\ACS 2011 Tables.mdb" tableList = arcpy.ListTables() for table in tableList: out_dataset = "E:\Database Project\ACS Estimate 2011\Data\To Database\Seq Tables.gdb" #Process: Sort arcpy.Sort_management(table, out_dataset, "GEOID ASCENDING", "UR") #Process: Delete Field arcpy.DeleteField_management(out_dataset, "FILEID;FILETYPE;STUSAB;CHARITER")
Here is the error message that I am getting,
Any help is appreciated. Thank you in advance.