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
    2015-02-03T15:49:42+00:00

    Thanks! I got excited of what you've said. 

    Actually I got the idea in importing/manipulating .csv, .xls , etc using ADO Library in VBA.

    Then I thought that would it be possible also in .dbf coz ODBC supports dBase files/ vfpTables. 

    So i just changed the connection string used in importing/manipulating other filetypes by just using this one I searched in Google (sorry I seldom use Bing. :D)

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YouDir_thatcontains_dbf_files\;Extended Properties=dBase IV;

    Someone must create a library that executes DDL/DML compatible with VisualFoxPro sql commands. I don't know, I'm just hypothesizing. Hahah :D

    Was this answer helpful?

    0 comments
  2. Anonymous
    2015-02-03T03:29:48+00:00

    Please elaborate further. What exactly do you mean?

    Was this answer helpful?

    0 comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2015-02-03T03:12:40+00:00

    Congratulations on coming up with still another option.

    If you'd like to share your solution, I would imagine a lot of the other posters in the discussion would be grateful for the assistance.

    Perhaps an enterprising developer will see it as a source of revenue and develop and sell the tools you mention. I don't know what the size of that market would be, though. Enough to justify the effort I would hope.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2015-02-02T22:06:06+00:00

    I used ADODB Connection in VBA to select and manipulate .dbf files in msaccess 2013.

    A li'l bit of coding but it worked for me!

    So, someone must create a library/functions/sync library to make this easier.

    Was this answer helpful?

    0 comments