Dreaded foxpro dbf importing problem

[Noel]

I've search the forum for historical thread successfully, but none of the solutions have worked for me. Depending on the approach I take, I get one of several common errors, including:

1) The most common ....."The external table is not in the expected format...", via:

DoCmd.TransferDatabase acImport, "dBase IV", "C:\Mydirectory", acTable, "J_SUMRY.dbf", "TEMP"

2) "The microsoft jet database could not find the object...", via:

DoCmd.TransferDatabase , "ODBC Database", "ODBC;DSN=Visual FoxPro;UID=;SourceDB=C:\Mydirectory;SourceType=DBF;Exclusive=No;Background Fetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;DATABASE=", acTable, "J_SUMRY", "tblTest_dbf"

Any help would be very much appreciated.

Noel