Trouble expoting a .txt file

[gbanks]

Using the code below to export a file to a location but for some reason I keep getting an error "runtime error 3011" "The microsoft jet engine database could not find the oblect." "Make sure the object exisits and that you spell it's name and path namecorrectly" . I made sure a named file was in the loaction but I'm at my wits end trying to figure this out. Thanks..



DoCmd.TransferText acExportDelim, "Feed Export Specification", "TableFeed", "\\EEE\Dfs\FS_RDG_Prod_01x\EEE Production\Databases\Info\FTP\issues.txt", True, ""

 

[DCrake]

Have you tried running this through a macro then convert to macro to vb to view syntax. It could be the path name it does not like. Can you do a dir() on the path?

 

[gbanks]

Got it. You idea put me on the right path. I broke it down in a macro and I found that someone modified the export query with a field that was not in the export spec and it caused it to fail. Thanks so much!!!