Having written MDB2DBC I have to caution you that it's dated and I'm not even sure it will handle newer versions of Access; it was written targeting Access 2000. It also used RDO....yech.
My advice would be to open a remote view to the access data and then store the local results to a permanent table.
>>Hi all, i need to import some field from an ACCESS database. No experience about this. Help please
>
>Try
MDB2DBC - Access to VFP Data Migrator Download #
9848>
>Haven't tried it myself.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05