Quick script to convert dbf for csv. Tested with large 2010 census block data

dbf_to_csv.py

"""
---------------------------------------------------------------------------
dbf_to_csv.py
Dana Bauer
Feb 1, 2012
---------------------------------------------------------------------------
"""

import csv
from dbfpy import dbf
try:
    dbfFile = dbf.Dbf(open(r'c:\projects\MN\MN_block_name.dbf','r'))
    csvFile = csv.writer(open(r'c:\projects\MN\MNblocks.csv', 'wb'))
    
    headers = range(len(dbfFile.fieldNames))
    
    allRows = []
    for row in dbfFile:
        rows = []
        for num in headers:
            rows.append(row[num])
        allRows.append(rows)
          
    csvFile.writerow(dbfFile.fieldNames)
    for row in allRows:
        print row
        csvFile.writerow(row)
        
except Exception,e:
    print e