I have clients that send text files to me to be imported to a database that I keep for them. I have imported several of these files in the past, but all of a sudden I am getting a strange error message.
Here is the scenario: I open my database and right click in the empty area of the Tables listing and choose Import. The file selection box opens and I can select the .txt file I want to import. There are actually 2 files I have to import. The first one imported no problem... but when I try to import the second one, I get the following error pop-up.
"The Microsoft Jet database engine could not find the object 'V:\LOAD\ICT\ICT PD031006 Pay Detail.txt' Make sure the object exists and that you spell it's name and the path name correctly."
Now I have opened this .txt file using Notepad and viewed it's contents, and when I try to import it, I have to navigate to it's location, so it's not like it's not there, or that I mispelled it's name.
I am lost, I have never seen a message like this.
Thanks in advance for your help.
Dave
Here is the scenario: I open my database and right click in the empty area of the Tables listing and choose Import. The file selection box opens and I can select the .txt file I want to import. There are actually 2 files I have to import. The first one imported no problem... but when I try to import the second one, I get the following error pop-up.
"The Microsoft Jet database engine could not find the object 'V:\LOAD\ICT\ICT PD031006 Pay Detail.txt' Make sure the object exists and that you spell it's name and the path name correctly."
Now I have opened this .txt file using Notepad and viewed it's contents, and when I try to import it, I have to navigate to it's location, so it's not like it's not there, or that I mispelled it's name.
I am lost, I have never seen a message like this.
Thanks in advance for your help.
Dave
