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

HenkvanVliet
HenkvanVliet Member Posts: 10
in NAV Tips & Tricks
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

Answers

  • badugan
    badugan Member Posts: 6
    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
    HenkvanVliet Member Posts: 10
    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
    HenkvanVliet Member Posts: 10
    Just tried 64 bits, Access 365, same thing,
    Anyone an idea?

Categories