Forum Discussion

Joachim2108's avatar
Joachim2108
Helper I
5 years ago
Solved

Decimal separator missing when importing data

Hi all,   I'm stuck with a very annoying issue - when I import data via an ODBC driver (connected to ERP software called Microsoft XAL), the decimals in the numerical collumns disappear!    E.g. ...
Need Help
  • Joachim2108's avatar
    Joachim2108
    4 years ago

    The solution in the end had to do with how I import my data. My organisation uses an Oracle Database (a very old 32 bit version), and when getting data, I would select "ODBC" which would then result in the issue of missing decimals. 

     

    The solution in the end was simply to select "Oracle database" when importing data. No issues followed after that.