Friday 11 July 2014

Exporting Excel worksheets to DBF files

I am working on development of Excel Add-in that exports data to DBF files. No data provider (ODBC, OLE DB, ADO.NET etc.) is required. Planned release date: August 2014.


  • Supported Excel versions: 2007 to 2013.
  • Supported DBF formats: dBase III Plus (0x03), FoxPro (0x30) (free tables, Memo support is yet to be decided upon). DBase IV support is yet to be decided upon.
  • Data types supported: Character, Logical, Date, DateTime, Numeric, Integer, Double, no Memo support yet.
  • Exports either whole worksheet or a rectangular contiguous range.
  • Automatically skips hidden columns and rows filtered out.
  • Determines the most suitable data type for each exported column. Data types can be manually overridden.
  • Allows to modify output table structure: names, data types, width, decimals; selected columns can be skipped
  • Allows to set code page mark.
  • The setup may request installing run-times for .NET 4.0 and VS2010 Tools for Office.









No comments:

Post a Comment