open files with a .dbf extension with MS Access

[capnhud]

I was wondering how do I go about opening a file with the .dbf extension with
MS Access?

 

[Donald A. Herman]

From the File Menu choose "Get External Data", Import.

--
Donald A. Herman
Software - Scheduler Pro, Disk Cataloger, Math Wizard
http://don_herman.tripod.com
Office Extras
http://don_herman.tripod.com/msoextras

 

[Cindy Winegarden]

Hi,

You may want to determine which database tool created the files. Many DBFs
can be opened by choosing DBase IV, although you may have trouble with Memo
fields. If they are Visual FoxPro (VFP6 and below) files you will need ODBC.
The latest FoxPro and Visual FoxPro ODBC drivers are downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates.

For Visual FoxPro 7 and above you may need to use OLE DB and ADO. Over time
new data features have been added to FoxPro tables and they are not
compatible with ODBC. However, DBFs created with VFP7 and above that don't
use the new data features will still be compatible with ODBC.

If you are using ODBC you'll need to determine if the DBFs are part of a
Database Container (DBC). Look in the folder where the DBFs are and if a DBC
file is present then you'll need to point your ODBC data source directly to
it, otherwise use the Free Tables option in the ODBC setup and point toward
the folder where the DBFs are located.