Error export a txt file

Topic

New Reply

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”, “\EEEDfsFS_RDG_Prod_01xEEE ProductionDatabasesInfoFTPissues.txt”, True, “”

Reply | Quote

Replies

Are you sure that the export specification exists, that the table exists, and that neither name is misspelled? The only way I know of to verify that an Export Specification has REALLY been saved is to try to import it into another database.

Reply | Quote

Yes eveything you mentioned is there? What else can it be?

Reply | Quote

What version of Access are you using? And also what version of Windows is it running on? If it’s Access 2007 running on Win7, you could be encountering a permissions issue – otherwise the only thing I can see is the path name where you are trying to store the text file. Can you do a manual export to that same location?

Reply | Quote

Fixed Wendell. Thanks. someone modified the export query and added a field that the specification did not recognize. this caused the export to fail. once i removed the extraneous field in the query it work fine….

Reply | Quote