export .dbf to .csv?

Question

Original User: Lynn_Carlson

Can someone help a python newbie with code to export .dbf to .csv?

arcpy.TableToTable_conversion seems to only work with .dbf and geodatabase.

arcpy.CopyRows_management doesn't allow for .csv

I'm not finding any Export commands for tables.

Thank you!

Clip_31.jpg

Clip_32.jpg

Clip_30.jpg

DanielStephen_2-1755286147701.png

JayantaPoddar_0-1621601415850.png

DanielStephen_1-1755285818857.png

LynnCarlson · Answer

Thank you - both options worked perfectly!

Anonymous User · Answer

Original User: Caleb1987

Here's another way (also from stack exchange):
import arcpy
from os import path as p

def TableToCSV(fc,CSVFile):
    
    fields = [f.name for f in arcpy.ListFields(fc) if f.type <> 'Geometry']
    with open(CSVFile, 'w') as f:
        f.write(','.join(fields)+'
') #csv headers
        with arcpy.da.SearchCursor(fc, fields) as cursor:
            for row in cursor:
                f.write(','.join([str(r) for r in row])+'
')
    print 'Created %s Successfully' %p.basename(CSVFile)

achapapkowski · Answer

Try using the python csv library and do something like this:
def get_rows(data_set, fields):
   with da.SearchCursor(data_set, fields) as cursor:
      for row in cursor:
         yield row
if __name__ == "__main__":
   data_set = arcpy.GetParameterAsText(0) # feature class/Table
   output = arcpy.GetParameterAsText(1) # csv file
   desc = arcpy.Describe(data_set)
   fieldnames = [f.name for f in desc.fields if f.type not in ["Geometry", "Raster", "Blob"]]
   rows = get_rows(data_set, fieldnames)
   with open(output,'wb') as out_file:
      out_writer = csv.writer(out_file)
      out_writer.writerow(fieldnames)
      for row in rows:
         out_writer.writerow(row)

Hope this gets you in the right direction.