Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save an excel workbook as a DBF file
I am trying to save my excel file as a DBF but the option is not there in the
"save file as" drop-down list. Any advice? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save an excel workbook as a DBF file
Are you using xl2007?
If yes, then this option has been removed. But if you have Access, then maybe you could paste into Access 2007 and save from there???? Ksmith916 wrote: I am trying to save my excel file as a DBF but the option is not there in the "save file as" drop-down list. Any advice? -- Dave Peterson |
#3
|
|||
|
|||
Ksmith916 wrote:
I am trying to save my excel file as a DBF but the option is not there in the "save file as" drop-down list. Any advice? 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 |
#4
|
|||
|
|||
Quote:
http://www.dbfview.com/convert-xls-to-dbf.html all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save a Range on a Workbook as a CSV File | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Excel 2k3: Workbook on network drive, when save creates new file | Excel Discussion (Misc queries) | |||
User cannot save excel file in workbook | Excel Worksheet Functions | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |