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!