The problem was in field id.
we loaded id '2e2' then the value was loaded to exponetional 2,00E+01 and then transfered to '20',
anothe id had value '20' and QV combunet 2 ids into 1.
so the solution was to load id as text.
see attached file.
doudle id.xls 164.0 K
what version of visual fox pro (VFP) do you have ?
i'm trying to read .dbf database table of VPF 9 but the odbc driver asking me for .dbc file (
SQL##f - SqlState: S1000, ErrorCode: 171, ErrorMsg: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\vfoxprotest\anagrafe\private.dbc.
SQL select * From `anagrafe.DBF`
I don't have .dbc file but only .dbf, .fpt and .cdx
Can you help me ?