M
Manuel
Hi,
I have a really simple DB. There's a table called Output which I'm trying
to export to a network location. I'm accomplishing this using the transfer
text macro command. Here are the details:
Export Type: Export Fixed Width
Specification Name: Output Import Specification1
Table Name: Output
File Name: V:\_LSOperationsSupport\Soares_Manuel\1st Lien Watch\Output.txt
Has Field Names: No
HTML Table Name: <Blank>
Code Page: <Blank>
This is the ONLY command for this macro and I'm not using another macro to
run this macro. When I run this macro I receive a message stating:
The Microsoft Jet database engine could not find the object 'Output.txt'.
Make sure the object exists and that you spelled its name and the path name
correctly.
I've confirmed numerous times that there is a file called Output.txt
residing in the folder denoted by the path noted above in File Name:, and
that the path name is correct (I copied and pasted the path from Windows
Explorer).
Curiously, whenever I run the macro and receive the above message, the
Output.txt file located at the above referenced path gets deleted. I'm not
using a delete command in the macro or any VBA whatsoever. Could someone
please shed some light here, give me any suggestions how to resolve this.
Thanks a bunch!
Manuel
I have a really simple DB. There's a table called Output which I'm trying
to export to a network location. I'm accomplishing this using the transfer
text macro command. Here are the details:
Export Type: Export Fixed Width
Specification Name: Output Import Specification1
Table Name: Output
File Name: V:\_LSOperationsSupport\Soares_Manuel\1st Lien Watch\Output.txt
Has Field Names: No
HTML Table Name: <Blank>
Code Page: <Blank>
This is the ONLY command for this macro and I'm not using another macro to
run this macro. When I run this macro I receive a message stating:
The Microsoft Jet database engine could not find the object 'Output.txt'.
Make sure the object exists and that you spelled its name and the path name
correctly.
I've confirmed numerous times that there is a file called Output.txt
residing in the folder denoted by the path noted above in File Name:, and
that the path name is correct (I copied and pasted the path from Windows
Explorer).
Curiously, whenever I run the macro and receive the above message, the
Output.txt file located at the above referenced path gets deleted. I'm not
using a delete command in the macro or any VBA whatsoever. Could someone
please shed some light here, give me any suggestions how to resolve this.
Thanks a bunch!
Manuel