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
    2015-03-11T19:41:33+00:00

    From this:

          ddlNewAccessTable = "CREATE TABLE " & dbfTableName & " " & ddlColumns & ";"

    Remove semicolon ; in the end:

          ddlNewAccessTable = "CREATE TABLE " & dbfTableName & " " & ddlColumns & ""

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-04-16T16:46:18+00:00

    Here is a program I created that can import multiple DBF files in a folder. It can also export your Access tables. Note you will need the registry files I added that link as will. You may have to change the connection strings for your version of access.

    VB Code

    https://onedrive.live.com/redir?resid=81C066941585FBAB!101960&authkey=!AHOT5thRrRUJyD4&ithint=file%2czip

    Registry and DLL file. / Will need admin rights to install registry files. This only adds DBF support

    https://onedrive.live.com/redir?resid=81c066941585fbab!575&authkey=!AKrTOswdJp_HLhA&ithint=folder%2creg

    Link to the various connection string if you need to change them

    http://www.connectionstrings.com/access/

    Hopefully this helps you.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2015-04-16T16:49:10+00:00

    Here is a program I created that can import multiple DBF files in a folder. It can also export your Access tables. Note you will need the registry files I added that link as will. You may have to change the connection strings for your version of access.

    VB Code

    https://onedrive.live.com/redir?resid=81C066941585FBAB!101960&authkey=!AHOT5thRrRUJyD4&ithint=file%2czip

    Registry and DLL file. / Will need admin rights to install registry files. This only adds DBF support

    https://onedrive.live.com/redir?resid=81c066941585fbab!575&authkey=!AKrTOswdJp_HLhA&ithint=folder%2creg

    Link to the various connection string if you need to change them

    http://www.connectionstrings.com/access/

    Hopefully this helps you.

    One final note the .dll file needs to be wherever the registry is pointing to. You can edit the registry files with a text editor, before installing them.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-04-16T23:59:57+00:00

    I would suggest you remove the dll from your OneDrive account.  It is illegal to distribute the file. 

    As has been noted earlier, if a user does not have it it can be obtained via the installation of the Access 2010 runtime.

    Was this answer helpful?

    0 comments