Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: Problem with macro // importing data

    I am using an Access DB created by a third party to import data from .DBF files into Access tables. The .DBF files containing the data are stored in a folder and the macro is importing from most of them with no problem. There are two files in the folder (I have verified several times that they exist) it keeps saying it cannot find. The specific error message is:


    The MS Jet Database engine could not find the object 'FILENAME.DBF'
    Make sure the object exists... If i click 'OK' it continues processing until it gets to the next file it can't find. Same two files are missed each time I run the macro.

    Any ideas as to why its just skipping some files and not all? Any help would be appreciated!

    -JD

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Problem with macro // importing data

    Originally posted by jdusc2002
    I am using an Access DB created by a third party to import data from .DBF files into Access tables. The .DBF files containing the data are stored in a folder and the macro is importing from most of them with no problem. There are two files in the folder (I have verified several times that they exist) it keeps saying it cannot find. The specific error message is:


    The MS Jet Database engine could not find the object 'FILENAME.DBF'
    Make sure the object exists... If i click 'OK' it continues processing until it gets to the next file it can't find. Same two files are missed each time I run the macro.

    Any ideas as to why its just skipping some files and not all? Any help would be appreciated!

    -JD
    Try to import them manually, I mean from the file menu and not using a macro, and see what will happen.

  3. #3
    Join Date
    Nov 2003
    Location
    Warren, PA
    Posts
    52
    I would double and triple check the path and the filename to make 100% sure that it is correct. I can’t tell you how many times I have overlooked a misspelled path or file name.

    Brent

Posting Permissions

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