Search code examples
pythondbf

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:\Users\caobaijing\Desktop\Betty\Python\MergeTables.py", line 7, in arcpy.Merge_management (listTable, "C:\Users\caobaijing\Desktop\Betty\Output\ppt.dbf") File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.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).

Solution

  • 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!"