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"
hope it helps someone next time! = )