The Microsoft Jet database engine could not find the object

The Microsoft Jet database engine could not find the object ‘ ‘. Make sure the object exists and that you spell its name and the path name correctly.

Microsoft jet database engine

Today I got this error when I was trying to import a CSV file into Access database 2003. Even though I was trying to load this from my C: drive I was getting this error.

After couple of tries found that filename “currentproc.20090531.csv” had an extra “.”  and that was the problem.

So renamed the file to 20090531.csv and it worked 🙂

Happy importing.

3 thoughts on “The Microsoft Jet database engine could not find the object

  • October 28, 2009 at 6:52 am
    Permalink

    Is there any way to avoid this error while reading csv files with an extra “.” in the file name?My problem is, I can’t change the file name.

    Reply
  • October 28, 2009 at 9:41 am
    Permalink

    Sorry. Thats the restriction with Access.

    If possible make a copy of the original file and process it automatically.

    Reply
  • January 4, 2010 at 9:34 am
    Permalink

    Thanks! I was searching for a solution for half a day.. I must say you can’t even use underscore in the filename, just numbers or letters. How crazy is it?! 😀

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: