Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

converting visual fox pro

Discussion in 'Information Technology' started by SAC, Nov 9, 2005.

  1. SAC

    SAC
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Basic Questions about Converting to Sikhism Questions and Answers Nov 15, 2013
    Converting to Sikhism Hard Talk Aug 31, 2012
    Why are people converting to Sikhism? Sikh Sikhi Sikhism Jul 1, 2012
    Question About Converting To Sikhism For A Married Person Questions and Answers Jun 3, 2012

  3. Cindy Winegarden

    Cindy Winegarden
    Expand Collapse
    Guest

    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.

    --
    Cindy Winegarden MCSD, Microsoft Most Valuable Professional
    cindy_winegarden@msn.com www.cindywinegarden.com
    Blog: http://spaces.msn.com/members/cindywinegarden


    "SAC" <sac@abc.com> 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
    > 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?
     

Share This Page