Forum Discussion

Copper Contributor

Jul 17, 2024

O365 Exporting files with multiple periods in file name using DoCmd.Transfertext stopped working

We upgraded from access 2013 to office 365 few years ago. And have been using Transfertext to export files in txt, xls, xlsx formats until last week. Many of the exported files have multiple periods ...

Brass Contributor

Jul 18, 2024

I can confirm the error message (VBA Error 13201) for Access 365 for both directions (TransferType) of DoCmd.TransferText. It sounds like the developers changed the Access spec and don't intend to solve the underlying problem.
I would therefore export to a temporary file (e.g. "tmp" & CLng(Timer() * 100) & ".txt") and rename it later.

ShivanandBaswann
Copper Contributor
Jul 18, 2024
Gerrit_Viehmann

Thanks Again. I did exactly same thing. Since the application is complex, and interfaces have already been developed and in place. I renamed file name wherever there was "." with "#" and exported the files. renamed them back to original file names with windows shell script. Had to account for "." in the folder path names.

Regards,
Shiva
- George_Hepworth
  Silver Contributor
  Jul 18, 2024
  Please confirm the version of Access you have installed so we can investigate. Please also notify your IT support of the problem. Ask IT to roll back the update. If they support you, they should be prepared to help with this problem until a fix is available.
  
  ALso, please provide an example of a file name with multiple periods in it.
  
  Every bit of detail you can provide is that much more detail that can be used to identify the problem.