DoCmd.TransferText acExportDelim Error

  • Thread starter Thread starter Gary Martens
  • Start date Start date
G

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?
 
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?
 
Thanks so much for going back and posting your own problem discovery. This one was eating my lunch also. Same issue - same fix.

Thanks
 
Back
Top