Morys,
The easiest method is to use ADO to query data from a VFP database.
Do the following:
1. Create a SYSTEM dsn called VFPADO (point it at your database)
2. Run the follwing code
Set oConn = CreateObject("ADODB.Connection")
oConn.Open "VFPADO","",""
Set oRecs = CreateObject("ADODB.Recordset")
oRecs.Open "Select * from customer",oConn,3,3
'Substutute your table above in the SELECT line
' and below in the fields list
Do While Not oRecs.Eof
Debug.print oRecs("Lastname")
oRecs.MoveNext
Loop
Hope that helps...
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.