"ERROR 160385: Workspace or data source is read only." when running ExportTable. Tried all solutions I've found so far...

MegRFay

Hi there,

I have run the code below on multiple occasions with no problems, but lately have been running into an error. I use arcpy.conversion.ExportTableto bring csvs housed on a network drive to tables in my working gdb (Code Below). I have tried the following solutions I found on Esri Community and GISStackExchange.

• Not enough memory - checked
• Insufficient permissions - checked, I have permissions for both the source and destination folders
• Need to reset your instance of ArcGIS - this did not resolve the error. 
• The help page is pretty unhelpful

I have also restarted my computer. When I check the output in the GUI, it seems some of the rows/observations in the csv are exported to the gdb before the error is returned. Any suggestions are more than welcome, but please check the error handling and previous attempts. Thank you!

# Step 4. Create tables from csv files

# set workspace to gdb
arcpy.env.workspace = gdb

for in_table in in_tables_ed:
    print(f"Processing {in_table}...")
    
    # Check if the input file exists
    if not os.path.exists(in_table):
        print(f"Error: {in_table} does not exist")
        continue
    
    # Resolve output name
    out_name = os.path.basename(in_table).replace('.csv', '')
    
    # Check if the table already exists in the geodatabase
    if arcpy.Exists(out_name):
        print(f"Table {out_name} already exists in the geodatabase. Skipping...")
        continue
    
    try:
        # Export the table
        arcpy.conversion.ExportTable(in_table, out_name)
        print(f"Converted {in_table} to table {out_name} in {gdb}")
    except arcpy.ExecuteError:
        print(f"Failed to export {in_table}. Error: {arcpy.GetMessages(2)}")
    except Exception as e:
        print(f"An unexpected error occurred: {e}")

 

MegRFay

Sometimes the error is " Error: ERROR 000224: Cannot insert features - The table was not found." Again, after some amount of rows have been exported. I am completely confused.