A family of Microsoft relational database management systems designed for ease of use.
Access 2013 - Dbase (.dbf) Table Import option
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.
158 additional answers
Sort by: Oldest
-
Anonymous
2013-09-24T12:38:55+00:00 You can try This Work Around
Here are some general steps on bringing in your dbase (*.dbf) files into Access as a local Access table:
1. Open your existing Access (*.mdb) database file using Access 2003
2. Rename or delete the linked dbase table
3. Go to File > Get External Data > Import
4. Change the Files of Type to dbase III
5. Select your dbase file and click Import
If you do not have Access 2000 or Access 2003 then you can try this as well
- We setup an ODBC DSN using the dbase driver and specified the directory as c:\dbase (ODBC Administrator can be found at c:\windows\syswow64\odbcad32.exe or the shortcut we placed on the desktop)
- In Excel 2010, Go to the Data tab > Get External Data - From Other Sources > From Microsoft Query
- Selected the DSN we created "Test dbase", clicked Ok
- Selected the dbase file to add and included all columns
- Clicked next through remaining options
- Clicked Ok to add the data to the current sheet in Excel
From here you would save the Excel workbook and then import the file into Access by going to External Data > Import & Link Group > Excel
-
Anonymous
2013-09-28T05:22:33+00:00 Yep. MS Access 2003 and 2010 both supported the *.dbf dbase III file import.
MS Access 2013 doesn't.
Why Microsoft? Why?
And when are you going to FIX IT!!!
-
Anonymous
2014-04-12T09:40:04+00:00 instalable ISAM file cannot be found
HELP
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?
Is Microsoft addressing their error?
OR are they simply ignoring this?
The last post on this thread was in March - it's now May 2013.
Come on Microsoft --- FIX IT !!!!!
I need the ability to import dBASE files ...
instalable ISAM FILE cannot be found when opening my work on my new MS AXES
-
Anonymous
2014-04-28T12:32:34+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?
Is Microsoft addressing their error?
OR are they simply ignoring this?
The last post on this thread was in March - it's now May 2013.
Come on Microsoft --- FIX IT !!!!!
I need the ability to import dBASE files ...
I have the same Problem.
dBase files are still in use from many programms.
I Need to read/write.
Best regards,
Christoph