Transferspread sheet importing some WRONG values! WHAT?!

[qwerty1]

I am trying to import an excel .xls file into a table in access.
Everything looks to be ok, but when you look at some of the values they are slightly wrong! This is unnaccepable and useless if it isnt 100%.

I am using:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_data", "C:\Filepath\File.xls", False

I look at the data, and Field 15. Most are correct but I have a value that should be 39.91 is imported as 33.91. And 37.31 is 33.31.



Please help!

[June7]

Want to provide the Excel file for testing?