Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Minnesota
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FoxPro ODBC Import (Access 2000)

    I am trying to import FoxPro data, and having major difficulty. I have a free table directory, and I have set up the ODBC data source as outlined in the help and other documentation. However when I get to Import Objects step, none of tables are shown.

    Thank you for your help!

    Susan
    Mgr, Research and Education
    HealthEast Care System

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FoxPro ODBC Import (Access 2000)

    Can you link to the tables?
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FoxPro ODBC Import (Access 2000)

    Did your tables have the extention .DBF ?
    Francois

  4. #4
    New Lounger
    Join Date
    Feb 2002
    Location
    Minnesota
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FoxPro ODBC Import (Access 2000)

    Charlotte asked if I can link to the tables - no I cannot.
    Francois asked if the tables have the .DBF extension - yes they do.

    Thanks for your help.

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: FoxPro ODBC Import (Access 2000)

    In what version of FoxPro are these tables? If they are old FoxPro 2.X tables you should be able to use the Free Table Directory option under "Database type" when setting up the ODBC Data Source using the Visual FoxPro driver. If the tables are created in Visual FoxPro 3.0 or later, then Free Table Directory doesn't work, you have to select the "Visual FoxPro database (.DBC)" option when setting up the data source. You would then browse for the path of the *.DBC file, which acts as a container for the Visual FoxPro tables (*.DBF files) (they would be in same folder). If set up correctly you should then be able to either link or import the Visual FoxPro tables.

  6. #6
    New Lounger
    Join Date
    Feb 2002
    Location
    Minnesota
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FoxPro ODBC Import (Access 2000)

    Thank you to everyone who has helped me out with this problem. In part, the problem was using the *.DBC file instead of the Free Table Directory (the tables were VFP v.6), but that wasn't the only issue. We also discovered a problem with the *.DBC file itself, it was whole enough to be read just fine by FoxPro, but damaged enough that it completely choked Access. We were able to copy over the files, and I can now read everything just fine. So many gray hairs for such a simple solution!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •