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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6928
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.
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy_winegarden@msn.com www.cindywinegarden.com
Blog:
http://spaces.msn.com/members/cindywinegarden
"SAC"
wrote in message
news:u8hBZgH5FHA.2432@TK2MSFTNGP10.phx.gbl...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6928
> 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?
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
