SaveDBF Excel addin - New Version is Now Available!

In addition to bug fixes, here are the highlights of the new added features:

• Tested with the latest Excel 2010 on Windows XP/Vista and Win 7 (also with Excel 2007).
• Replaced the Microsoft database driver with my own that creates native binary DBF files. MS is slowly phasing out the DBF capabilities in its driver and this step had to be made sooner or later. No relying on MS database features anymore!
• Added the option to over-write the original DBF file (a backup is created).
• Added the option to auto-fix column names in an Excel file (this is limited to removing leading and trailing spaces automatically and replacing illegal characters with an underscore).
• Added the option to convert an Excel file to ALL TEXT fields based on the width of the columns. This is a great feature for labeling programs.
• There are no longer any issues with dashes/spaces etc in the file name or worksheet tab name! Any names are allowed.
• Excel files that contain error values are now converted and the error values are automatically replaced with a blank.
• Hidden columns are identified.
• Even more improved error handling and many more!

Many tireless weekends of development and testing went into this version so I hope you will like it!

Thank you for your patience!

Yeah nice, but can your add-in deal with very large DBF files?

Of course it can. Mind you the maximum is 1,048,575 records...which is the limitation of the Excel 2007 worksheet.

Check out the YouTube video below.



Quite a few people are using the add-in with engineering applications (like SCADA) and with geographic information systems (ArcInfo, ArcMap etc.).

I already have plans for an even more advanced version specially for engineers. Planned features will likely include:

• ability to overwrite the original dbf file (of course a date stamped backup file would be created to ensure no loss of data)
• ability to over-ride the add-in defined field sizes. The add-in is pretty good at defining the field types and sizes from the data, however engineering systems might require a pre-defined field size. So the add-in will make suggestions, a popup shows with the suggestions, user can over-ride or just click ok.
• batch processing capabilities
• even more improved error-handling capabilities

So what d'ya say? What's your fancy? Suggestions are welcome!!!

You can download the add-in on the right in the sidebar.