Monday, March 28, 2011

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!

5 comments:

Anonymous said...

Oh NM - i see your next post is about 32-bit Office vs 64-bit Office and it looks like I'm running 64-bit!

Janice Ong said...

I tried. For 5000+ lines file, when saved, it became 31 lines only.

P/s: I am also running on 64-bit

nikkisa889 said...

I found your blog website on google and verify a number of of your early posts. Continue to maintain up the superb operate. I simply extra up your RSS feed to my MSN Information Reader. Searching for forward to studying more from you afterward!… best online casinos

Unknown said...

Microsoft Technical Support Number Australia- +61-290-520-846 provide support for all the issues that arises out of various Microsoft products like Microsoft Azure, Office 365, Microsoft Exchange Server, Microsoft Outlook and various other products and services.

Microsoft Online Support Number Australia
Microsoft Helpline Number
Microsoft Contact Number Australia
Microsoft Technical Support Number

Alfred said...

Very informative blog, If you want on Online Excel Database than use Turnao's service they offer free service for personal/ single user, Turnao is web-based application used to
convert excel spreadsheets to online databases
.