DoCmd.TransferText acExportDelim Error

[Gary Martens]

When I try to export to a text file from within a module
(that I've run many times before) I get the error:

Run-time error '3011':

The Microsoft Jet database engine could not find the
object 'myfilename#txt'. Make sure the object exixts and
you spell its name and path correctly.

The filename 'myfilename.txt' is stored correctly with
full path and filename to the variable 'moutfile' I use in
the line:

DoCmd.TransferText acExportDelim, "SASRGTXT", "tempout",
moutfile

This program worked a few weeks ago before loading service
pack updates. Another thought is that I need to use a
different reference.

Any ideas?

 

[Gary Martens]

I discovered that the problem was caused by renaming a
field in the export table 'tempout', which then did not
match the field name in the export
specification 'SASRGTXT'. Too bad the error message is not
more helpful eh?

 

[Guest]

Thanks so much for going back and posting your own problem discovery. This one was eating my lunch also. Same issue - same fix.

Thanks