Solved

How do I import a .dbf file into Excel or Access 2007

Posted on 2014-02-04
3
2,428 Views
Last Modified: 2014-02-04
I'm trying to open up some database files that drive an old DOS program.
Some of the .dbf files have opened in Excel.  Others won't, so I'm trying to convert them to open in Access.  Have just downloaded the free 30 trial version of Microsoft Office 15 which has Access 2007, however the 'Import & link' part of 'External Data' within Access 2007 does not give you the option to import .dbf files.
Please can anyone help before I throw this computer through the window!!
Cheers
0
Comment
Question by:bluesgirl101
3 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 250 total points
ID: 39832752
When you install Access, you have to do a full install or a custom install that includes the drivers you want.

I'm not sure what Office 15 is but A2013 does NOT include support for .dbf files.  You need A2010 or earlier.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39832907
I believe "Office15" is the 2013 version. As Pat mentioned, it won't import dbf files.
0
 

Author Closing Comment

by:bluesgirl101
ID: 39832991
Thanks guys
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now