topic Table to Table Function in Python in Python Questions

Table to Table Function in Python

StevenRehbaum — Fri, 08 Apr 2011 12:52:47 GMT

I am going to run a weekly script that updates POIs for some Garmin units my group has. My output is a .dbf that will be converted to .csv and then loaded. My final operation of the model/script is Table to Table. I need to have this .dbf overwritten each instance it is run. My geoprocessing overwrite function is turned on and runs fine in ModelBuilder, but it will not overwrite the .dbf from the script and gives me the Error 000258 stating the table already exists. I wasn't sure if I was missing something or there is some snippet of code which will allow the .dbf to be forcibly overwritten. I know I could just write the first part of the model/script to delete the existing one before it runs again, but I was hoping not to do so. Any help is greatly appreciated.

arcpy.TableToTable_conversion

Re: Table to Table Function in Python

ZoeZaloudek — Sat, 11 Dec 2021 10:16:27 GMT

I usually set the OverWriteOutput to 1 at the beginning of my scripts. I'm using 9.3, so I'm not sure how this translates over to 10 & arcpy... But it's probably similar.

# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create()

# Set the Geoprocessing environment...
gp.OverWriteOutput = 1 #Overwrite set to true

Re: Table to Table Function in Python

StevenRehbaum — Sat, 11 Dec 2021 10:16:30 GMT

I usually set the OverWriteOutput to 1 at the beginning of my scripts. I'm using 9.3, so I'm not sure how this translates over to 10 & arcpy... But it's probably similar.
# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create()

# Set the Geoprocessing environment...
gp.OverWriteOutput = 1 #Overwrite set to true

I knew it was something like that! 🙂 Worked perfectly. Many thanks.