Have you tried setting your decimals to 5 before running the query?

Regards,
Jim

>Hello all
>I'm converting MS Access table via ODBC and copying the resulting cursor to a Foxpro table. The Access table has a numberic field with 5 decimal places. When I copy it to Fox DBF table only 2 decimal place is given.
>Is there any way to bring all 5 decimal place over?
>
>lcSQLCommand = "SELECT * FROM MyAccessTbl"
>lnGetData = SQLEXEC(lnConnHandle, lcSQLCommand, 'newdata')
>select newdata
>copy to
>
>This only brings in 2 decimal places on a field that has 5 decimal places (i.g. 9.03421%)
>
>Thanks