Re: How to fish out data from .fpt / .cdx files (Foxpro?)

From: Cindy Winegarden (cindy_winegarden_at_msn.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 13:07:59 -0500

Hi Ang,

As you've discovered, FoxPro and Visual FoxPro files come in 3 parts. The
DBF is the table itself, The CDX (if present) is the index file, and the FPT
is the contents of memo fields in the main table, if there are any. You
would not access the CDX and FTP files directly; the FoxPro data engine
reads them if it needs to.

You may also see a DBC which is a Database Container that holds metadata
about Visual FoxPro tables. (It's index and memo files are DBX and DCT.) If
the DBC file is present then you would want to set up the ODBC data source
to access a database rather than a free table directory.

There is also an OLE DB data provider for FoxPro and Visual FoxPro. 

-- 
Cindy Winegarden  MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com  www.cindywinegarden.com
"Ang" <angbeer@verizon.net> wrote in message
news:GAWld.5483$GV5.2638@trnddc04...
> uhhh, sorry to bother you all. I've figured it out, or at least the nuts
> and
> bolts of it. ...guess I was tired last night.
>
> By the way, in case anyone else is trying to fiddle with Foxpro files, you
> have to load the Foxpro driver via ODBC data sources.
>> How do I access (no pun intended) data in files with an extension of
> either
>> ".fpt" or ".cdx" ?

Relevant Pages

  • Re: Visual Fox-Pro - not really OT
    ... Visual FoxPro is a Microsoft database program, ... Raceform Interactive is a subscription product. ...
    (uk.sport.horseracing)
  • Re: Linking to DBF FoxPro files
    ... Start with the latest ODBC driver for FoxPro and Visual FoxPro, ... Now open up the ODBC dialog. ... Data Sources. ... Scroll down to the Microsoft Visual FoxPro Driver. ...
    (microsoft.public.access.queries)
  • Re: Visual FoxPro 6.0
    ... Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: ... Now open up the ODBC dialog. ... Data Sources. ...
    (microsoft.public.access.externaldata)
  • Re: Can an access form write to a dbf file?
    ... it does seem you have FoxPro files. ... Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: ... Now open up the ODBC dialog. ... Data Sources. ...
    (microsoft.public.access.forms)
  • Re: how to convert Access 97 to Access 2003
    ... Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: ... Now open up the ODBC dialog. ... Data Sources. ...
    (microsoft.public.access.gettingstarted)