I'm trying to convert excel files to dbf(dBASEIII) using python and my current process is:
- Use xlrd to convert the excel file to a .csv
- I take the headers off of the .csv and I use
- Take the newly made .csv and use the dbf module (https://pypi.python.org/pypi/dbf) to convert to dbf
I remove the headers from the csv file and I run the following:
table = dbf.from_csv(origfname, filename='test.dbf', field_names=headers, dbf_type='db3')
As of now, when the process is over all the fields become memo fields, how do I make them into Char, Date, Number, etc... fields?