Using ODBC im****t

I want to use VBA to im****t/link VFP dbf to Access. And try to use below
coding:

DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=PROD;" & _
                "SourceDB=E:\work\Access\;SourceType=DBF;Exclusive=No;" &
_
               
"BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes", _
                acTable, "temp.dbf", "acc_temp", False

But a run-time error (3146) is popped up. 

I try to im****t/ link the dbf file by manual. Click "File->Get External
Data-
>Im****t (ODBC Database)->Machine Data Source (PROD)..."
It does work. 

Would any one please advise what the problem is?
Thank you very much.

JW