1. docmd.transferdatabase......
You could do that if you're using VBA in MS Access 95 or later. From a VB5 or later project, you must open a Reference to MS Access object library for to use DoCmd object.

2. ADO
The popular way. You must create a DSN pointing to your FoxPro, Text File or Access table (obviously, you must install the drivers). Then, get records from Source Recordset, build a SQL's INSERT INTO, execute on Target Recordset, and so on.

I'm not sure, but I believe there is other better ways, some command on ADO for transfer tables or maybe it only exist on VBA for Access.

glurrea