Using ODBC import

[JackyWen]

I want to use VBA to import/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 import/ link the dbf file by manual. Click "File->Get External Data-

Import (ODBC Database)->Machine Data Source (PROD)..."

It does work.

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

JW

 

[JackyWen via AccessMonster.com]

Would anyone help me?