dbf2csv

1.安装dbfpy

下载:
http://sourceforge.net/projects/dbfpy/files/latest/download?source=files
安装:
sudo python setup.py install

2.py脚本

#!/usr/bin/python

import csv
from dbfpy import dbf
import os
import sys

filename = sys.argv[1]
if filename.endswith('.dbf'):
    print "Converting %s to csv" % filename
    csv_fn = filename[:-4]+ ".csv"
    with open(csv_fn,'wb') as csvfile:
        in_db = dbf.Dbf(filename)
        out_csv = csv.writer(csvfile)
        names = []
        for field in in_db.header.fields:
            names.append(field.name)
        out_csv.writerow(names)
        for rec in in_db:
            out_csv.writerow(rec.fieldData)
        in_db.close()
        print "Done..."
else:
    print("Filename does not end with .dbf")

3.执行

python dbf2csv.py CLK.dbf

转载于:https://www.cnblogs.com/levy/p/dbf2csv.html