Access 2013 - Dbase (.dbf) Table Import option

Anonymous
2013-02-03T16:16:55+00:00

I need to be able to import read/write Dbase dbf tables - yes they are still around so why has the standard option that was in Access 2010 gone?

I have seen mention of ISAM, which is gobbledegook to me. So please a simple answer - what do I need to install or change and how do I do it?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
ScottGem 68,840 Reputation points Volunteer Moderator
2016-09-08T09:08:22+00:00

Was this answer helpful?

60+ people found this answer helpful.
0 comments No comments

158 additional answers

Sort by: Most helpful
  1. Anonymous
    2013-07-14T10:17:03+00:00

    No need to save as csv, just save as Excel workbook, then import directly into Access. Alternatively, if you have an earlier version of Access, import the dbf tables then save the database as .accdb. You can then work on it in Access 2013, but a nuisance if you need to update or add new dbf tables.

    Nothing excuses Microsoft for not consulting their customers ( I see that they have now updated Windows 8 under customer pressure to make it look like Windows 7 for business/serious users) and the absurdity that Access 2013 can read dbf files, but with no direct import option.

    Keep sticking it to MS through this and other forums!

    Was this answer helpful?

    0 comments No comments
  2. George Hepworth 23,120 Reputation points Volunteer Moderator
    2013-07-13T23:19:39+00:00

    As others have pointed out, the decision by the Access team to drop support for direct import of .dbf files reflects the need to prioritize resources as much as it does anything else. The major investment in Access 2013 was in web apps. It is sad that some valuable and useful features were sacrificed. However, there is a perfectly viable workaround, even if it's sort of klunky. Open the .dbf file in Excel and resave it as a .csv file.

    On the other hand, it does seem disingenuous that Access can no longer support the .dbf format while Excel can. Makes one wonder, doesn't it?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-06-27T14:04:56+00:00

    MICROSOFT, ARE YOU KIDDING!  One of the best features of Access was universal connection to so many different databases.  Many, including myself, have built around this concept to create applications that integrate tables from different vendors and now we have to go find a new solution?  It doesn't make sense for an UPGRADE to to be USELESS!

     

    I'm unhappy with no support for DBF files as well.  I have also found this page that seems to suggest, they have no thoughts about adding it either!

    http://office.microsoft.com/en-us/access-help/discontinued-features-and-modified-functionality-in-access-2013-HA102749226.aspx

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2013-05-11T16:30:57+00:00

    Thank You!  

    Yours was a/the very helpful response.

    I'm (trying to) switch from MS Access 2003 to 2013 and am *NOT* at all happy nor impressed .....

    Was this answer helpful?

    0 comments No comments