Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Location
    Bucharest
    Posts
    11

    Unanswered: Link to .dbf table in Access

    hi,

    I am trying to link a .dbf table in Access 2000 as dBase IV, but I got the error message: External table not in expected format.

    I think the problem is, that I have a memo field in the .dbf table.
    Additional I have a fpt file. I read some messages in this forum and I realised that I have a FoxPro table, and that's why I got the message.

    Do I have to use a ODBC or can I make it simplier? If I do have to use ODBC, how doe it works?

    Thanks in advance,
    Eniko

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    When I go to link a table, I have the option of Microsoft FoxPro in the Files of type pull down list. If you do not have it, you may be able to add it by going through the Access installer and choose more database drivers.

  3. #3
    Join Date
    Dec 2003
    Location
    Bucharest
    Posts
    11
    hi,

    thanks for suggestion, but I don't have Microsoft Foxpro in the list. Only dBase formats...
    and the company policy makes it difficult to run the installer on my desktop.
    are you sure, that this is a solution? In this case I will try it again and again till I get the installer.

  4. #4
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I don't have a foxpro file with which to test this solution and I am using access 97. This is just one possible solution. It may work, but without being able to test it, I can't say for sure. If you have ODBC drivers for foxpro (probably also available from the Access installer), that is just another possible solution.

  5. #5
    Join Date
    Dec 2003
    Location
    Bucharest
    Posts
    11
    I searched for that driver.

    really, in Access 97 I have the option for Microsoft FoxPro, but in Access 2000 not.

    I tried to search for installer on microsoft.com and I found one installer, but it:

    ...does not include Microsoft Jet, the Microsoft Jet OLE DB Provider, the Desktop Database Drivers ODBC Driver, or the Visual FoxPro ODBC driver.

  6. #6
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    Access 2002/XP does not have FoxPro in the Files of type list either, but adding a new odbc driver, I found several VFP entries which may be what you need. Check if that is in Access 2000's add ODBC driver. To get there, I chose Link table and from the Files of type list, I choose odbc. I had to click the add a new driver button from there.

  7. #7
    Join Date
    Dec 2003
    Location
    Bucharest
    Posts
    11

    Talking

    Thanks a lot,

    it works

Posting Permissions

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