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