>>Thanks, Wayne. But once I've made the ODBC connection, I don't know the Access syntax to view the files and copy the selected info that I need.
>
>Make the connection in ODBC then in VFP...
>
>lnconnect = sqlconnect('myaccessconn')
>
>lnresult = sqlexec(lnconnect,'select * from tableinaccess','_resultset')
>
>
>HTH
>Wayne

After configuring a DataSource in the ODBC Manager, you can create a database in Visual Foxpro:

Modify Database accessdb1

And then, visually create a 'Connection' to the Data Source, and 'Views' for the tables that you want to access:

Right-click, Connections, Add
Right-Click, New Remote View, New View

After that, you can access the data through the created views, like a local DBF.
(USE, BROWSE, ETC)