first u create odbc connection to access database
then run sqlconnect() command, this command connect foxpro to access database
then run sqlexec() command and get your required data into any cursor
then copy data from cursor to any foxpro table

example

*assume odbcname is accessdata

a=sqlconnect(accessdata)
sqlexec(a,"select * from emp",'cursor1')
select * from cursor1 into table table1

hope it will help u