Text files specification does not exist (Run-time error 3625 RRS feed

  • Question

  • Hello all.  Hoping that I can finally get to the root cause of this error.

    Running Access on 365ProPlus.

    I created an import text specification and named it "import" and then created the following sub

          Private Sub Import_Click()
            DoCmd.TransferText acImportDelim, "Import", "Transactions", "c:\users\owner\downloads\transactions.csv"
         End Sub

    When running this sub, i keep getting the run-time err 3625 indicating that the spec does not exist.

    I have confirmed the file does exist using the saved import of the same name ("import")

    Can anyone tell me what I might be doing wrong and where the specification files are stored?

    Thanks! Jim B

    Saturday, April 14, 2018 6:33 PM