[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1167
  • 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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