I've used DoCmd.transfer text with other projects to export a table in Access to a text file, and I am trying to do the same here, but with no success.
Code:
Public Function EXPORT_Inspections()
DoCmd.TransferText acExportFixed, "Export1", "Inspection_EXPORT", "c:/exp.txt", True, ""
End Function
I keep getting:
The Microsoft Access database engine could not find the object <name>. Make sure the object exists and that you spell its name and the path name correctly. (Error 3011)
Anybody have an idea about that?
Thanks,
J