It could be something as simple as:

m_conn=sqlstringconnect("dsn="+m_yourdatasourcename)
=sqlexec(m_conn,"select * from accesstable","MyCursor")

m_yourdatasourcename is the name of the datasource created in the odbc manager to connect to the access database.

Take a look at the functions

sqlstringconnect

and

sqlexec

In VFP Help


>Where could I get some simple example how to read some Access data files from VFP? I never work with ODBC - so where should I start?
>
>Thank's, Zlatko.