Error 3011 When Importing Text

[Bonediggler1]

Hello-

I have a simple bit of code to import text files using the CreateObject(scripting.filesystemobject) etc method. I use it in many different apps without problem.

Anyway, in the latest app I can sometimes import the text files and sometimes not. When I can't, I get the "The Microsoft Jet Database Engine could not find the object blah.txt. Make sure the object exists and that you spell its name and the path name correctly."

I have tried reducing the overall length of the path name with no success.

Any ideas???


Thank you!!

 

[vbajock]

Does the path name have a space in it?

 

[Bonediggler1]

Never mind...

I wasn't including the path name, only the file name. Not sure how the files ever got imported in the first place without a path name though.