how to save excel data into dbf format?

[Bhaskar]

how to save excel 2007 data into dbf format

 

[Jacob Skaria]

Bhaskar,

2007 do not support some file types which were previosuly supported. DBF 3 &
DBF 4 formats are in this list which may be opened but not saved using 2007.

If this post helps click Yes

 

[Jacob Skaria]

Bhaskar,

2007 do not support some file types which were previosuly supported. DBF 3 &
DBF 4 formats are in this list which may be opened but not saved using 2007.

If this post helps click Yes

 

[Bob I]

Send it to Access 2007 first.

 

[Bhaskar]

is there any update or patch or add-in in excel 2007, to enable me to save
excel data in dbf4 format?
To while URL should i convey this to develop such a feature

 

[Bob I]

It was dropped, use Access 2007 to Export to DBF 3, 4 or 5.

 

[gygulyas]

Save/Edit DBF file in Excel 2007

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 http://thexlwiz.blogspot.com/.


Gyula