IMO the easiest way is adding a Foxpro tables as linked tables to your Access database. You could add a linked table from menu File->Get External Data->Link Table. In the Link dialog box select ODBC Databases() from the Files of type list. Then select a "Visual FoxPro Tables" from Machine Datasource tab. After adding a linked table you might use it exactly as a native Access table and work with a live data.

>Hi. I need to query my Foxpro 2.6 tables as a basis for a report written in Access. I assume the best way to do this is via an ODBC driver, but I'm not sure how to get it to work. I've done this before using MS-Query and the Foxpor driver that shipped with Office 97/Ms-Query, but I don't know what to use with Office XP - Access.
>
>Currently the only way is to copy the tables to excel and do it that way, the problem is that the data is not 'live' and this process must be repeated daily.