DoCmd.TransferSpreadsheet acImport in MS Access issue RRS feed

  • Question

  • I'm using DoCmd.TransferSpreadsheet acImport to import numbers to access table.

    The range of numbers: from 0 to 5000. The numbers are different, it could be 0.00034 and 1000.001 so I put the Double, Standard and 9 decimal places in the field parameter in table.

    So it works perfect on my PC and several PCs of my colleagues. But on another several PCs this function rounds small values to "0". For example 0.0002 shows as "0" after importing.

    I supposed there is an issue with ms access and windows settings.

    So I compared the regional formats on PCs (the same), checked the settings of access (the same).

    What could be the reason of rounding to "0" small amounts on several PCs?

    Using MS Access 2016


    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "table01", myPath, False, "Sheet1!A1:W50000"

    Thanks in advance.

    Monday, July 20, 2020 6:54 PM