Forum Discussion

JAZ_OV's avatar
JAZ_OV
Copper Contributor
Jul 14, 2022

Windows or Office 365 Updates on 7/12/22 Introduced Error with TransferText in vba for Access

After the above noted updates I have received several reports of Access error 3125.  I have traced this issue to a saved import specification.  Below is an example of the error when using an import s...
access
office 365
arnel_gp's avatar
arnel_gp
Iron Contributor
Jul 14, 2022
can you fully qualify the text filename with the Correct Path, eg:

C:\theFolder\Scan2.txt
  • JAZ_OV's avatar
    JAZ_OV
    Copper Contributor
    Jul 14, 2022
    I've tried that with the same results. The only thing that throws the error is using a saved specification. Thanks for the suggestion.
    • JAZ_OV's avatar
      JAZ_OV
      Copper Contributor
      Jul 14, 2022
      Oops, Edit to previous post - won't do anything without the RunSQL :

      Open CurDir & "\Scan.txt" For Input As #1
      'Get a record
      While Not EOF(1)
      Input #1, vID, vRec
      vsql = "INSERT INTO RetestResponses(StudentID, Responses) VALUES (" & CStr(vID) & Chr(44) & Chr(34) & vRec & Chr(34) & ");"
      DoCmd.RunSQL vsql
      Wend
      Close #1
      • Diegomarino's avatar
        Diegomarino
        Copper Contributor
        Jul 16, 2022
        hi, i got the same problem. So the only workaround is to read the file and add values row per row, right?
        i'm not a great programmer, i'm wondering if they will solve the issue soon, i mean if there is some official communication

Resources