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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-03-06T08:09:49+00:00

    I am afraid, what you have experienced, is the MS "wall to keep users out of their way" technique.

    They don't care.  They would actually rather have dumped Access long time ago.  Shows clearly when looking at what has happened with Access till now.  Degrading is their biggest "achievement".

    Guess the only possible way is to stay with 2010 like some old guy (like myself) in here said, that also has given up hope.

    User voice is, as far as I can see, just a container.

    Sorry for all of us.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-03-06T13:24:08+00:00

    They would actually rather have dumped Access long time ago.  

    User voice is, as far as I can see, just a container.

    Sorry for all of us.

    There have been rumors like that for decades. It wasn't true then and its not true now. I have been involved with people who have been part of the Access dev team for the last 10 years. I'm not going say there haven't been issues, especially between Access 2010 and 2016, but I can say that the people who manage Office have never wanted to "dump" Access.

    I don't know what you are looking at but you clearly can't see very far. Uservoice is paid attention to. It will help to promote it, not tear it down.

    I'm sorry for you. I don't know what your agenda is, but if you want Access to improve and affect changes, it certainly doesn't help to put up posts like you did. Posts that have no factual basis and just promote gloom and doom.

    Was this answer helpful?

    0 comments
  3. 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
  4. 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