simple TransferText acExportFixed problem

[hawkpig]

Hi chaps

I was wondering if anyone has experienced a similar problem before.

I have a script that exports a query to a text file. It is to a fixed length text file. Each time I run the script it fails with:

*************
Runtime error '3011'

The microsoft Jet database engine could not find the object outboundfile#txt'. Make sure the object exists and that you spell its name and the path name correctly.

*************

So if I create a file called outboundfile#txt' in the correct location and run the script again, it deletes the original and then comes up with the error again.

Below is my code, have I missed something?


***************************

Function make_outbound()

Dim diallerfile As String

diallerfile = "c:\dialler\outboundfile.txt"

DoCmd.TransferText acExportFixed, "exportdialler", "C01 DIALLER FILE", diallerfile

End Function

***************************

 

[gemma-the-husky]

the transfer text command has 6 parameters . the second parameter is a file spec. i'm not sure what your 4 parameters are, so i would check them again

ie - is exportdialler the name of an imp/exp file spec