>Çetin, I am somewhat amazed over this, being 100% new to ODBC. I checked out your faq#8039, made a small prg and lo and behold - it all worked beautifully. Access DDB tables flying into Fox files. So thanks. As for the reversion - i.e. going Fox to Access, it's not at all clear to a OCBC newcomer like me yet what to edit in your prg but I'll get the magnifying glass out. THANKS Denis

Denis,
Automation from VFP side is also an option :

#DEFINE acImport	0	
#DEFINE acTable	0	

lcMDB = GETFILE('MDB')
lcVFPDataPath = _samples+'\data\testdata.dbc'
oAccess = CREATEOBJECT("Access.application")
oAccess.OpenCurrentDatabase(lcMDB,.f.)
oAccess.DoCmd.TransferDatabase(acImport, "ODBC Database", ;
    "ODBC;DSN=Visual FoxPro Database;UID=;PWD=;" +;
    "SourceDB="+lcVFPDataPath+";SourceType=DBC;",;
    acTable, "Employee", "VFPEmployee")

Cetin