• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1187
  • Last Modified:

DoCmd.TransferText file name CANNOT have multiple . if not error 3011

hey guys,

not really a question but just want to share with yall cause it caused me quite a bit of time (when i have none!!! = ((   )

ok so basically when you're importing a text file using DoCmd.TransferText, your text file cannot have multiple dots. this was the name of my text file

"Work Hours 27.05.2013IMPORT.txt"

it kept giving me error 3011 saying it can't find the file.

MS probably did a read from the left to find the first dot ha (i think!! = P  )

anyway i just removed all the dots using a replace function and then inserted the last dot in

strFilePath = Replace(strFilePath, ".", "")
    strFilePath = Left(strFilePath, Len(strFilePath) - 3) & ".txt"

Open in new window


hope it helps someone next time! = )
0
developingprogrammer
Asked:
developingprogrammer
1 Solution
 
developingprogrammerAuthor Commented:
hi Jim, okie dokie, here's the additional comment i'll post to accept as answer.

with super experts like yourself, Christian and all the others posting articles, i don't think i'm really "fit" to post an article at the moment. when i improve more and really become better, i mayyyy just be good enough to post an article then! thanks Jim!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now