This script uses the dbfpy module from http://dbfpy.sourceforge.net/.
import csv
from dbfpy import dbf
import sys
dbf_fn = sys.argv[1]
csv_fn = sys.argv[2]
in_db = dbf.Dbf(dbf_fn)
out_csv = csv.writer(open(csv_fn, 'wb'))
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()
from dbfpy import dbf
import sys
dbf_fn = sys.argv[1]
csv_fn = sys.argv[2]
in_db = dbf.Dbf(dbf_fn)
out_csv = csv.writer(open(csv_fn, 'wb'))
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()
Had a similar problem and solved it with PERL and DBI:XBase:
ReplyDeletehttp://blog.dev001.net/post/14563495366/converting-dbf-to-csv-files