I am trying to export tables from Access 2013 into Excel 2013. Decimals other than .00, .25, .5, and .75 export incorrectly into Excel.
For example
Access value Excel Value
231.01 231.009994506836 232.6 232.600006103516
232.70 232.699996948242 233.0 233.0 235.8 235.800003051758
Any idea what is going on here? If I copy the values directly from the Access table and paste into an excel table the extra decimal values are not added, it only occurs when I use the export option in Access. I cannot copy and paste because I often need to export >100,000 records at once.