I am attempting to use the docmd.transfertext command to export the contents of a table to a text file. I created the Export specification and it can be run successfully manually. But when I create the code for it, I get the following error:
"The text file specification does not exist. You cannot import, export or link using the specification."
My code is:
I saw something that said this was a known bug addressed in Service Pack 1 which is: 14.0.6024.1000
However, I am running: 14.0.6117.5000 which appears to be a later version.
Appreciate any suggestions and / or workarounds.
"The text file specification does not exist. You cannot import, export or link using the specification."
My code is:
Code:
DoCmd.TransferText acExportDelim, "Export-ExportDataToHyperion", sExportTable, sExportTargetFile, True]
I saw something that said this was a known bug addressed in Service Pack 1 which is: 14.0.6024.1000
However, I am running: 14.0.6117.5000 which appears to be a later version.
Appreciate any suggestions and / or workarounds.