Error 3044 when importing a dbase file into access

[egstatus]

Hi all,
I am trying to import a dbase III file into access, this is a manual process that I have right now. However I would like to automate it.

I am getting erorr 3044 at the following line of code.
The file does exist, it is in a network server.
I have tried both of the lines below and still get the error.
Don't know what to do. I have changed the 'Dbase III' to 'Dbase IV' and made no difference.

The error is
<Path> is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. (Error 3044)

My Code is:

        'DoCmd.TransferDatabase acImport, "dBase III", "\\status51_01\Vol1\Ezc\9JM6869S.DBF", acTable, "9JM6869S", "9JM6869S"
        DoCmd.TransferDatabase acImport, "dBase III", "f:\EZC\9JM6869S.DBF", acTable, "9JM6869S", "9JM6869S"

I have even move the file to my PC and still get the error; however if I use the 'Get External Data' 'Import' Functions from the tool bar, it works.

Thanks in advance

EG

 

[egstatus]

Nevermind,
I finally figured out.

This solved the problem

DoCmd.TransferDatabase acImport, "dBase III", "f:\EZC\", acTable, "9JM6869S.DBF", "9JM6869S"

Thanks again.
EG