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