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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-02-03T21:32:10+00:00

    My code is here (import .dbf to msaccess2013)

    Help me modify for better results.

    Thanks buddies!

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2015-02-03T19:42:28+00:00

    I've got it!

    I successfully imported .dbf to Ms Access 2013. It took 5 secs for 1MB File about 11,000+ rows and algorithm can be further optimized.

    Supports basic types TEXT,MEMO,DATETIME,DOUBLE,YESNO data types.

    The algorithm goes like this:

    1. Connect to .dbf using ADO
    2. Extract columns names and datatype
    3. Generate Access CREATE TABLE DDL from extracted columns of .dbf
    4. Execute obtained CREATE TABLE DDL.
    5. Extract rows from .dbf then insert to new table.
    6. Import finished.

    Anyone still interested? :D

    Was this answer helpful?

    0 comments
  4. George Hepworth 23,120 Reputation points Volunteer Moderator
    2015-02-03T16:51:41+00:00

    Excellent. Where there's a will, there's a way.

    Was this answer helpful?

    0 comments