Just an idea how to read a data from MDB to VFP. Next step (from VFP to SQL) should be easy.

LOCAL oRS as ADODB.Recordset
LOCAL oConn AS adodb.Connection

lcConn=[Provider=Microsoft.Jet.OLEDB.4.0;] +;
[Data Source=\\Conseqdbs\Data\Access\Contrade\Contrade.mdb; ]+;
[Jet OLEDB:Database Password=xxxxx;]+;
[Jet OLEDB:System Database=s:\Conseq1.mdw;] +;
[User Id=user;Password=yyyyy]

oConn = NEWOBJECT("adodb.connection")
WITH oConn
.ConnectionString=(lcConn)
ENDWITH
oConn.Open
oRS = oConn.Execute("SELECT [Clearing účet Journal New].CSORTKEY, [Clearing účet Journal New].SETTLEDATE FROM [Clearing účet Journal New];")
oRS.Fields("settledate").Value

bye