|| at Jun 7, 2010 at 1:47 am
On 06/06/2010 06:59 PM, noydb wrote:
On Jun 5, 9:31 pm, Tim Chasewrote:
Many thanks Tim, this worked well!
In the interest of learning, anyone have a XLS to DBF solution?
This becomes considerably trickier unless you're willing to have
all your DBF fields be CHAR-format rather than their actual
data-type. In an Excel file, one column can hold multiple
data-types (text, numbers, formulas, dates, currency, etc)
whereas (from my humble understanding) a single column in a DBF
must be of the same data-type.
That said, if you want to attempt it, I'd suggest usinghttp://dbfpy.sourceforge.net/
to create the DBF files using code similar to my CSV version
(which mostly iterates over the Excel workbook and dumps the
contents to CSV files -- just change it to dump the contents to