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
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

158 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2016-05-22T11:55:44+00:00

    We listen, we try to follow "process" to get MS to listen (just as you say).

    But they do not engage they do not care.

    The ultimate arrogance and ignorance that will cost them customers.

    Was this answer helpful?

    0 comments
  2. George Hepworth 23,120 Reputation points Volunteer Moderator
    2016-04-20T15:32:59+00:00

    Yes, that would work in versions of Access prior to 2013.

    The point here is that support for dbf linking was dropped in the 2013 version.

    I'm sure that the Access team is highly aware of the problem and taking it seriously. I don't know what to expect in the future, though.

    So, please, keep voting at the UserVoice form to let them know it is important to your business.

    Thanks.

    George Hepworth

    Access MVP 2007-2016

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-04-20T13:37:09+00:00

    Have you gotten that to work on a fresh OS and Office install?  This is precisely the code that no longer works.  Thoughts??

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-04-20T12:31:10+00:00

    For anyone with this issue you can link to a DBF table using code similar to below, (note that error checking etc ought to be included) AND obviously change the hard coded names to whatever is required

    Dim tdf As TableDef

    Set tdf = CurrentDb.CreateTableDef("NameYouWant")

    tdf.Connect = "Dbase III;Database=c:\test\dbase"

    tdf.SourceTableName = "example.dbf"

    CurrentDb.TableDefs.Append tdf

    Was this answer helpful?

    0 comments