runtime error 3125 on transfertxt

[diegomarino]

hi, i have procedure in which i have this line

      DoCmd.TransferText acLinkDelim, "PuntoEVirgola", "FilialiTemp", Fl, True

"puntoevirgola" is a different delimitation character
fl is "C:\Users\diego\desktop\2022-07-08_SUCCURSALI_BANCHE.csv"

it gives me the 3125 runtime error.
It worked before, then i formatted my pc and didn't work again, now i made some changes but i get always the same error

[CJ_London]

What is the description of error 3125?

[diegomarino]

here you are



that means: [nameoffile] is not a valid name. verify that not includes characters o punctuation not valid e that is not too long.


i used a procedure too to change file name just in "filiali" but i had the same issue

[CJ_London]

Don't see anything wrong with the filepath/name as such - what happens if:

- you create a file manually in file explorer on your desktop?
- you hardcode the filepath/name rather than using a variable?

and since you have not provided all the code - suggest debug.print fl before the transfertext line to check the whole path is provided

however just googled your problem and found this link

https://techcommunity.microsoft.com/...th/m-p/3572587

[diegomarino]

ok, i think it's a bug, damn. hope they solve soon

[Welshgasman]

That link mentions problem with previous spec?
Recreate the spec and try that?

[diegomarino]

i deleted the row of my spec in the query and recreated that, no result, same error

[diegomarino]

i think the only way is to uninstall latest updates, i'm trying to do that but even if i uninstall it i find always the last update when i restart the pc. i set updates paused for a week