Thank you very much, I had almost junked my Office 2007 as there was no Save AS DBF, After downloading your revised version, It works great, only difference I see is it makes longer than requred character and number fields, but that is no big deal.

Overall it works better than Office 2003 after using quick acces toolbar, Thanks a lot again

Hi there,

just wanted to let you know that I released a new version of the add-in that enables saving a DBF file in Excel 2007.

New features:

1. Now you can add/insert new fields, create calculated fields in addition to adding new records or editing existing records in your native DBF file!

2. If you start with an Excel file the software now have enhanced capabilities to determine the field types (better than Microsoft's own in earlier Excel versions).

3. The add-in checks DBase field naming conventions and also identifies duplicate fields. All problem field names are visually identified with a cell comment!

4. If you start out with a brand new file and forget to save it, the add-in will ask before the conversion.

5. Large files are supported. I edited files over 500,000 records with no problem.

See the post at thexlwiz.*************.

Gyula

Hi there,

just wanted to let you know that I released a new version of the add-
in that enables saving a DBF file in Excel 2007.

New features:

1. Now you can add/insert new fields, create calculated fields in
addition to adding new records or editing existing records in your
native DBF file!

2. If you start with an Excel file the software now have enhanced
capabilities to determine the field types (better than Microsoft's own
in earlier Excel versions).

3. The add-in checks DBase field naming conventions and also
identifies duplicate fields. All problem field names are visually
identified with a cell comment!

4. If you start out with a brand new file and forget to save it, the
add-in will ask before the conversion.

5. Large files are supported. I edited files over 500,000 records with
no problem.

See the post at theXLwiz.

Gyula

Dear Fellow DBF Users,

The latest upgrade of the SaveDBF Excel 2007 add-in (used to be called XLSX2DBF) can be tried at thexlwiz.*************.

The changes include fixes related to minor bugs in Microsoft's OLEDB engine and some improved field type identification for users who start out with an Excel file.

Future plans:

I plan one more upgrade in Jan/Feb 2010. This will be a major upgrade with lots of planned improvements as listed below:

- Add a Preference window where users can set to:

Overwrite the original DBF file (and create a date-stamped backup file in the same folder)
Mimic Microsoft's Excel 2003 behaviour (i.e. automatically replace spaces in field names with an underscore, accept field names longer than 10 characters)

- Add a Data Conversion window where the user can change the field type and size from what the add-in determined from the data. This is useful for people who start with an Excel file with data that do not necessarily reflect the maximum field size for a character field, for example. The add-in will guess the maximum size from the data, but the user can over-ride it in the new window. Or you can simply click OK and the add-in will behave exactly as it does now.

- Batch processing capabilities (i.e. calling the macro from a third party program (e.g. Python or Perl or C++ etc) and mass-process many files without user interaction.

- Improved speed for very large DBF files and a progress bar with % complete reported.

If you have other improvement ideas this is the time to email them to me at gygulyas - a t - yahoo - dot - ca!

Thank you very much for your continued support!

Long live the DBF!

Gyula

Thanks this was informative

this is brilliant - just wondering if you know what the error 13 is when saving?

cheers
Mike dJ

When I try to unzip SaveDBFIV it tells me that the file is corrupt. What's wrong?

I also tought there were no means to launch the converter but, after searching all the GUI, found the option "dBase IV DBF" as the last option in the menu "Save as" under the Excel orb (below "Other formats") . The dBase IV type is not added to the generic "Save As" dialog and does not appear if you press F12 or use a quick button from the custom bar.

Besides that, I successfully converted files (even if the string fields are huge).

Thanks to Majorde for this add-in!

Help, I tried to open the zip file and I get a message that it is invalid or corrupted.

Hi there,

just wanted to let you know that I released a new version of the add-in that enables saving a DBF file in Excel 2007 and 2010.

New features:

1. Now you can add/insert new fields, create calculated fields in addition to adding new records or editing existing records in your native DBF file!

2. If you start with an Excel file the software now have enhanced capabilities to determine the field types (better than Microsoft's own in earlier Excel versions).

3. The add-in checks DBase field naming conventions and also identifies duplicate fields. All problem field names are visually identified with a cell comment!

4. If you start out with a brand new file and forget to save it, the add-in will ask before the conversion.

5. Large files are supported. I edited files over 800,000 records with no problem.

6. Added the option to overwrite the original dbf file (a backup is created). The dbf file is compact and does not 'bloat' in size!

7. 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.

8. 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).

See the post at thexlwiz.*************.

Gyula

Thank you Majorde, you've saved my bacon (or at any rate, you've saved me much frustration).
Regards

my english is very poor.
I downloaded the zip file,but don't exacted. would you mail the zip files?
thanks.

It took so much of my time to figure it out too.
I found it at the left panel (NOT at default "save as" button)
It is at File>Add-in>Save as>DBFfile

Note: EXCEL 2010


Anyway, the VBA conversion failed! "Project or library not found" =.=

Hey good stuff but got compilation error "Can't find project or library"
Can anyone help

Hello,

I think a moderator should delete gygulyas posts, as a f**** publicity !

Majore, thank you for your free tool, there is some bugs but it's helpfull and free...

à plus

Pascal