I am trying to do an an import for a dBase III file. It works fine in Access when I navigate to the file and use the built-in Import. You can see in my code that I have a Dir run first. The Dir finds the file fine; yet, the docmd aborts with error 3044, invalid path name. The variable strPath is a Variant. (I've also tried String.)
I don't understand how Dir finds the file and considers it ok, but docmd fails.
Can anyone help on this?
If Dir(strPath) <> "" Then
DoCmd.TransferDatabase acImport, "dBase III", strPath, acTable