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

From: Ang (angbeer_at_verizon.net)
Date: 11/15/04

  • Next message: Robert Gillard: "Re: Can you do this with a macro" 
    Date: Mon, 15 Nov 2004 04:50:46 GMT

    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.

    "Ang" <angbeer@verizon.net> wrote in message
    news:CMCld.3247$GV5.551@trnddc04...
    > QUESTION:
    > How do I access (no pun intended) data in files with an extension of
    either
    > ".fpt" or ".cdx" ?
    >
    > BACKGROUND:
    > I don't know beans about databases. I always meant to fiddle with Access
    and
    > learn more about database stuff. But I never did. So then, the company I
    > work for bought some other company and inherited some files that appear to
    > have been created using some iteration of Foxpro(???). I've been poking
    > through these files to see if there's anything in there that we can use.
    One
    > area of these files that I've been homing in on consists of about 25 files
    > with extensions such as .dbf .frt .frx .cdx .fpt, etc. Of those files,
    > there's a 15Meg "dbf" file, a 1.5Meg "cdx" file, and a 3Meg "fpt" file
    that
    > appear to contain data I could potentially use. The other files are mostly
    > less than 100K in size so I've set those aside for the time.
    >
    > This weekend I updated my Office to 2003 and spent some time reading a Que
    > book about Access. (....errrrrr, the 97 version; surely database stuff
    > hasn't changed that much?) Then I started puttering around with these
    files.
    > After receiving the message "External table not in expected format," I
    > cheerfully abandoned Access and opened the "dbf" file in Excel.
    > I couldn't figure out how to do much with the ".cdx" file. There appears
    to
    > be some stuff (text fields) in there that I'd like to get at, but since I
    > was bombing, I turned to the ".fpt" file. I wasn't able to do much with
    that
    > either, but of course I clicked away madly and opened the file in Word.
    > There is data (text descriptions) in that file which I would like to
    rescue.
    > Can anyone either explain what I'm fiddling with or point me towards some
    > web links where I can educate myself?
    >
    > Thanks,
    > Ang
    >
    >

  • Next message: Robert Gillard: "Re: Can you do this with a macro"

    Relevant Pages

    • Re: Disobeying jet engines - why?
      ... fiddle with databases. ... I think even more would-be programmers have simply been sold a bill of goods ... by those who'd like to sell you databases, RTOSes, etc. in the first place -- ... they have a difficult time conceiving how the problem ought to be solved "from ...
      (sci.electronics.design)
    • Re: Basics
      ... I noticed that but I plan to use the same controls to fiddle with several ... databases so the prospect of rebuilding them is not the ...
      (borland.public.delphi.database.ado)