You could probably find a way to automate it via VBA code in Access --or-- do something from the Fox side via ADO. It shouldn't be that daunting, if you really want to hide the complexity from the user(s).
>
>>I did it, no problem. But I had to tell the Import dialog that it was an ODBC database and in that dialog, use the VFP table driver.
>
>Sheesh! yes it does work, oc. I was HOPING that my poor naive Access user wouldn't have to go through all these steps:
>
>Get External Data
>Import
>Files of Type: ODBC
>Machine Data Source: Visual FoxPro Table
>Locate table
>Import Objects - choose table
>
>Oh well.
>
>Thanks again for checking for me.
>
>J
------------------------------------------------
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