>>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)
Just an opinion... Not a fact.