Skip to content
Advertisement

How to merge a list of dbf tables into one in Python?

I want to merge a lot of dbf tables in my “Output” folder, into one table. Here is my code, but it doesn’t work (error showed below).:

import arcpy     
import os

arcpy.env.workspace="C:\Users\Desktop\Betty\Output"
listTable = arcpy.ListTables ()
arcpy.Merge_management (listTable, 'C:\Users\Desktop\Betty\Output\ppt.dbf')
print "done!"

Traceback (most recent call last): File “C:UserscaobaijingDesktopBettyPythonMergeTables.py”, line 7, in arcpy.Merge_management (listTable, “C:UserscaobaijingDesktopBettyOutputppt.dbf”) File “C:Program Files (x86)ArcGISDesktop10.1arcpyarcpymanagement.py”, line 3762, in Merge raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Datasets: Dataset **does not exist or is not supported Failed to execute (Merge).

Advertisement

Answer

For others who find this, the code works just fine. Must have been a path error or no dbfs in the workspace directory.

import arcpy

arcpy.env.workspace = 'C:/junk/tables'
listTable = arcpy.ListTables()
arcpy.Merge_management(listTable, 'C:/junk/tables/ppt.dbf')
print "done!"
User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement