Forum Discussion
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 in the file names.
All of a sudden we are getting error message to remove multiple periods and exports are aborting.
Few users of the application are on Access 2013 and we don't see any issue with 2013.
Is there a solution or fix for above issue?
Thanks in Advance
Shiva
5 Replies
- 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.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
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.
Hi,
> until last week
Then you should check if there were recent Office or Windows updates that caused this problem. Depending on what versions, builds and update status you have:
1. by comparing your machines/systems
2. by reverting to a previous Office build
3. by uninstalling recent Windows updates
Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. NürnbergThanks a ton for the response.
Unfortunately, the updates for windows and development tools are pushed by another group in the organization. I have no control over it. I just have to find a workaround for the issue. It happens with Win-X and Win-XI computers. Win-& seems to be working fine!
