Text Import unknown error on known good code (VBA)

Question

Recently I have been encountering errors on import with text delimitated files (.txt) using saved MS Import Specification schemas.  There is no error description and the error number = 0.  The problem is intermittent, I am utilizing MS Access 2016 on a Win 10.3 Networked computer.  Suspect problem to be related to the network memory or processing?  Is there a recommended resolution that does not entail administrative privileges?  Any coding in VBA to help overcome the errors?  As indicated there is no problem in the VBA coding simple line:

DoCmd.TransferText acImportDelim, "SchemaName", "TableName", TextFilePath, False

Any assistance would be greatly appreciated!

Answer 1

Hi. Just to be clear, are you saying the same exact .txt file will fail sometimes but would work without any problems at other times? If you're saying the same code works for some .txt files but not for others, then I would check the .txt files first.

Answer 2

Yes the exact .txt file will import, I may have to step through the code a couple of times to force it to run.  Problem is intermittent mainly related to large files approximately 5Meg and greater.  

Answer 3

No programmatic solution identified. Simply keep clicking the command button until it runs without error third time is usually the charm.  Just another networking issue to contend with.

Answer 4

Are you using a persistent connection?

---

Just takes a click to give thanks for a helpful post or answer.
Please vote “Helpful” or Mark as “Answer” as appropriate.
Chris Ward
Microsoft Community Contributor 2012