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
Work as if you don't need money
Love as if you've never been hurt before
Live as if this is your last day to live
Dance as if no one's watching