Link FoxPro .dbf to MS Access XP

[theking]

Having trouble linking a FoxPro database table (from a commercial
software program - CPRPlus: www.cprplus.com) to MSAccess.

I am only given the option to link to .dbc files, yet all the files from
the program are .dbf. There are a couple of .dbc files, but they don't
contain the tables I need to link to.

I'm don't know FoxPro's file formats very well. Should there be a .dbc
somewhere containing all the tables or can I link directly to the .dbf.
If so, how?

Thanks.

--
Posted via http://dbforums.com

[Cindy Winegarden]

Hi,

I assume you're using ODBC. The latest ODBC driver for FoxPro is
downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx.

There are several types of FoxPro files that need to be present in order for
you to link successfully. FoxPro table files are DBFs. If they have indexes
there will be CDX files present matching the DBF table names. If the DBFs
have memo fields there will be FPT files present matching the DBF table
names.

Visual FoxPro tables can be "free" tables or can be "contained" in a
"database container" or DBC file. (It's index and memo files are DCX and
DCT). The DBC contains metadata related to the database and the tables it
contains, such as long field names, persistent relations, stored procedures,
etc.

When a DBC is present you should link to the DBC. After you choose to link
to the DBC, a list of the tables it contains will come up and you can choose
the ones you want to see.

Post back if this does not help you do what you want.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.wi...@mvps.org, www.cindywinegarden.com

"theking" <membe...@dbforums.com> wrote in message
news:3388894.1...@dbforums.com...