Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    43

    Unanswered: Cannot import dbf file

    I'm trying to transfer data between a Filemaker 7 database to an MS Access database. I export the data to a dbf file, but when I try to import it in Access, it protests: "Can't find the object 'companies.dbf'. Check that the object exists and that you've provided the correct path". This is a rough translation of the error by the way.

    Access asks me which file I want to import, I browse to and double-click the file, but Accesss can't find the file. What's going on?

  2. #2
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by Oddish
    I'm trying to transfer data between a Filemaker 7 database to an MS Access database. I export the data to a dbf file, but when I try to import it in Access, it protests: "Can't find the object 'companies.dbf'. Check that the object exists and that you've provided the correct path". This is a rough translation of the error by the way.

    Access asks me which file I want to import, I browse to and double-click the file, but Accesss can't find the file. What's going on?
    Hi Oddish,

    What is the Native file format for Filemaker 7?? Did you try to see if Access could import the file direct from Filemaker instead of the exported DBF file?

    have a nice one,
    BUD

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if there is no native import / export ie filemaker to access in either program then I'd be tempted to try a CSV or delimited text export in preference to going through another database format.

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Quote Originally Posted by Oddish
    I'm trying to transfer data between a Filemaker 7 database to an MS Access database. I export the data to a dbf file, but when I try to import it in Access, it protests: "Can't find the object 'companies.dbf'. Check that the object exists and that you've provided the correct path". This is a rough translation of the error by the way.

    Access asks me which file I want to import, I browse to and double-click the file, but Accesss can't find the file. What's going on?
    Hi,

    In my experience, Access can no longer (2000 and above, I think) directly import dbf database files. You have to go thru ODBC. Do you know how to do that?

    Sam

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Try renaming the file. I have run into cases where I could only use eight characters to the left of the '.' This phenomena goes back to old file naming rules 8.3. Eight to the left and three to the right.

    You can test it by renaming the file to Test.dbf

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926

    Importing a dbf file

    I haven't had any problems importing dbf files into Access XP. I'm guessing your problem has something to do with the file itself or where it's saved. Try saving it to another location and then importing it.

  7. #7
    Join Date
    Mar 2003
    Posts
    43
    Thanks for all the answers! It seems the name was the problem, because it worked fine when I chose a shorter name.

Posting Permissions

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