Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unable to open dbf with Excel

    I am unable to open DBF files with Excel 2010. Not given the option within 'Open with'. If I choose Excel.exe from the 'Browse' option, nothing happens. It is as if Excel does not exist when trying to open DBF files.
    Last edited by kkratz; 2015-07-23 at 13:29.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K.,

    It sounds like you are trying to open it from File Explorer? If so, try opening it from within Excel you should have more luck. As an alternative you can go into File Associations and associate the .dbf file type with Excel which should allow you to open it from File Explorer.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Silver Lounger
    Join Date
    Mar 2014
    Location
    Forever West
    Posts
    2,072
    Thanks
    0
    Thanked 259 Times in 248 Posts
    Excel should open a .dbf file unless something is wrong with it. A list of programs that can handle the type:
    http://fileinfo.com/extension/dbf

  4. #4
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can open a DBF from within Excel but I can't refresh a pivot table with an external DBF source. As an aside, I was able to get File Association to show Excel as the opening file by choosing Excelconvert first as a bridge. However, even though it shows the Excel icon, nothing happens when I try to open the DBF file from Explorer.

    Quote Originally Posted by RetiredGeek View Post
    K.,

    It sounds like you are trying to open it from File Explorer? If so, try opening it from within Excel you should have more luck. As an alternative you can go into File Associations and associate the .dbf file type with Excel which should allow you to open it from File Explorer.

    HTH

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K.,

    I no longer have any .dbf files to test with could you post one that I could play with?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    There is nothing wrong with the DBF files, I can open them with Excel on another machine. I suppose this is a file manager problem.qm_dict.zip I can only open this one within Excel, If I use File Manager, Excel is not an option or it presents the Excel icon but nothing happens when selected.

  7. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K,

    Ok, here's what I did.

    1. Went to "Change File Type Associated" {enter in search bar}
      ExcelDBF3.JPG
    2. Select "Change the file type associated with a file extension" from the search results.
    3. I had no listing for .DBF - can't change here!
    4. Returned to File Explorer
    5. Right-Click on your .DBF file
    6. Select Properties.
    7. Next to Opens with: Click the Change... button
    8. Click More Options.
    9. Select Microsoft Excel.
      ExcelDBF.JPG
    10. Click Apply -> OK
    11. Double-Click your .DBF file and it opened right up in Excel.
    12. Returned to "Change File Type Associated and .DBF is now listed w/Excel as the program so ANY .DBF file should open with a Double-Click from File Explorer.

    ExcelDBF2.JPG
    HTH
    Last edited by RetiredGeek; 2015-07-24 at 10:02.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  8. #8
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    My problem is that excel was not presented in step 9. I got it there finally by associating excelcnv.exe with DBF and then associating Excel.exe with DBF. Trying to associate Excel.exe with DBF did nothing.
    When I double click on a DBF file nothing happens. If I go find Excel.exe and try to select it, I get returned to the file menu with the DBF file highlighted. 'Open with' gives me the choice of Adobe reader or Excel but choosing Excel does nothing. Maybe Adobe has claimed exclusive rights to the DBF?

  9. #9
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K,

    Did you scroll to the bottom and Select More Options?
    You should then be able to navigate to: C:\Program Files (x86)\Microsoft Office\Office14
    And find Excel.exe there.

    Note Office14 = Office 2010 depending on your version you may have a different number.

    I don't know why you didn't get it as an option with out going to this level but there may be something amiss in your Office install?

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  10. #10
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I did that with select more options. I also reinstalled Office 2010 with the same result. It is a real pain having to open and save the dbf as an Excel file before updating the pivot table.

  11. #11
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    K,

    One other thing I can think of, which probably doesn't apply but can't hurt to try. Is the .dbf in a Trusted Location? If not try placing it in one or defining the directory holding the file a trusted location. HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  12. #12
    New Lounger
    Join Date
    Jan 2011
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It is in a trusted directory. I can't even open on my desktop. Guess I will continue to open and save with Excel until I am forced to upgrade to Win10
    Thank you for your input.

Tags for this Thread

Posting Permissions

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