Import from NAV2016 with ODBC to access, only gives 2 decimals result, but field has 5 decimals.

HenkvanVliet

Hi all,
Import from NAV2016 with ODBC to Access, only gives 2 decimals result ´rounded', but the Navision field has 5 decimals.

Anyone an idea?
regard,
henk

badugan

Are you importing into Access? If you are, have a look at the column definition.. ensure it is enough decimal places have been allocated to the relevant column (decimal (13,2)) ??

HenkvanVliet

Hi Badugan,
thnx, but I already see the 2 decimals in the "link management" (if this is the right translation from Dutch).
This is before I use a query to import. The table where i import to has for this field double precision with 5 decimals. I use Access 2010, 32bit.
When using a jetreport the decimals appear correctly.

HenkvanVliet

Just tried 64 bits, Access 365, same thing,
Anyone an idea?