Importing txt file creates error

[Sheryl Stout]

I am trying to import a text file into Access 2002 (Office
XP). Both the file and the Access program are located
locally on my PC. When I choose File - Get External Data -
Import and choose the text file, I get the following
error message: "The Microsoft Jet database engine could
not find the object <filename>. Make sure the object
exists and that you spell its name and the path name
correctly". I have applied all service patches to both
Access and the Jet database engine. Any suggestions?

 

[John Nurick]

Hi Sheryl,

Not sure what could be causing this. Things to try:

1) Can you import other textfiles? if so, it's something different about
this one.

2) make sure the textfile has a conventional .txt or .csv extension

3) try moving and/or renaming the file so the total length of the path
and filename is 64 characters or less.

The following links may help:

"Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407

How to Import a Text File That Has an Extension That Access Does
Not Recognize (Q306144)
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q306144