converting visual fox pro

[SAC]

what file extension type do I need to convert a visual fox pro app to ms
access?

I've copied the dbf's, cdx's, and a dbc. After I've set up the ODBC and
then attempt to link to the dbc I get and error saying I'm missing the dct.

Are there any other files I need? Do they all need to be in the same
folder?

How can I or can I just link to a dbf like we used to be able to do?

Thanks.

 

[Cindy Winegarden]

Hi ,

Over time new data features have been added to FoxPro tables. Older-format
tables can be directly linked to in Access but newer format tables require
ODBC. Furthermore, tables using the very latest data features (added in VFP7
and beyond) are only accessible via OLE DB.

A FoxPro table comes in 3 parts: the table itself is a DBF, the index (if
the table is indexed) is a CDX and the Memo fields (if there are any) are
stored in FPT files. Similarly, a "database container" (DBC file, has
metadata and stored procedures) has a DBC for the table portion, a DCX for
the index portion, and a DCT for the memo portion.

So, you'll need the DBFs, and CDXs and FPTs if present) that have the same
name as the DBFs, the DBC and the matching DCX and DCT file is the DBC is
present.

A database container can "contain" tables that are in different directories
since it has relative paths to them.