+ Reply to Thread
Results 1 to 9 of 9

Save as dbf in Excel 2007

  1. #1
    Registered User
    Join Date
    02-02-2009
    Location
    Orangevale, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Save as dbf in Excel 2007

    My understanding is that it is no longer possible to save files in dbf format, as one could in versions 1997-2003. Does any one know of a work-around or add-in that will enable this function?

  2. #2
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295

    Re: Save as dbf in Excel 2007

    I use FoxPro, and face the same problem. There are ways to read Excel 2007 files and save them to dbf from FoxPro. What language or application are you using to read the dbf?

  3. #3
    Registered User
    Join Date
    02-02-2009
    Location
    Orangevale, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Save as dbf in Excel 2007

    I am saving the file to a dbf format, then using it in the FAA's Integrated Noise Model.

  4. #4
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295

    Re: Save as dbf in Excel 2007

    I've had a look on their website. The application has 1000+ users, so they must have come across this issue already. Do they provide a contact for support?

    I also did a search for xlsx to dbf converters through google and came up with the ABC Amber converter, which looks promising and won't break the bank at $19.95. Go to http://www.processtext.com/abcexcel.html. No doubt there are others.

    hth
    Mike

  5. #5
    Registered User
    Join Date
    02-02-2009
    Location
    Orangevale, CA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Save as dbf in Excel 2007

    Thanks. I have also re-installed Excel 2000, which retains the dbf output feature. Excel 2008 for Mac has the same problem, and also deletes the statistical functions (tool-paks). The official MS response to a similar query was to install Excel 2004 for Mac!

    Unbelieveable that MS deletes technical features as they go....

  6. #6
    Registered User
    Join Date
    07-01-2009
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Save as dbf in Excel 2007

    XLSX2DBF is an Excel 2007 add-in that helps convert and/or save a native DBF file that was edited with Excel 2007.

    Two common scenarios are supported:

    A) Open a native DBF file in Excel 2007 Make changes Save as a native DBF file with the changes.

    B) Open/create an Excel file that looks like a database (headers/columns/rows) Save as a native DBF file.

    http://thexlwiz.blogspot.com/

    Gyula

  7. #7
    Registered User
    Join Date
    07-29-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Save as dbf in Excel 2007

    My understanding is that it is no longer possible to save files in dbf format, as one could in versions 1997-2003. Does any one know of a work-around or add-in that will enable this function?


    fishnet body stocking
    Laser body hair

  8. #8
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,321
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  9. #9
    Registered User
    Join Date
    07-01-2009
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Save as dbf 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1