Incorrect value when exporting to Export

W

Weili

Hi,

I use DoCmd.TransferSpreadsheet to export data from Access
2002 to Excel. the number in Access was 2.7 but it became
2.699999999983 in Excel. Does anyone know why?

Also it happened the same problem when I built a external
data query in Excel to Access.

Thank you for help very much!

Weili
 
Top